CODEWITHSUNDEEP
qliksense
Marta
Marta

Reputation: 1

Failed visualization of bar charts in Nprinting

I am working with NPrinting (power point type) connected to a Qlik Sense app. I inserted stacked charts, but when converting the report into the power point, I came across this situation:

However, when I right click on the chart in the power point, edit and open the excel all values are displayed in the table, so I don't get why they cannot be visualized in the chart.

In Qlik sense, I inserted a formula directly in the measure of this type to format the values:

= if(SUM([Amount]) > 1000000000,  num(SUM([Amount])/1000000000 , '#,##0.0B'),
if(SUM([Amount])> 1000000,  num(SUM([Amount])/1000000 , '#,##0.0M'),
if(SUM([Amount])> 1000,  num(SUM([Amount])/1000,  '#,##0.0K'),
num(SUM([Amount]), '#,##0.0'))))

What can be the issue?

Thanks a lot for your answer!

I've tried to

However, no improvement so far.

Upvotes: 0

Views: 231

Answers (1)

SmoothBrane
SmoothBrane

Reputation: 931

In Qlik you should be able to modify your expression to look something like this:

=Dual(
    if(SUM([Amount]) > 1000000000
      , num(SUM([Amount]) / 1000000000, '#,##0.0B')
      , if(SUM([Amount]) > 1000000
          , num(SUM([Amount]) / 1000000, '#,##0.0M')
          , if(SUM([Amount]) > 1000
              , num(SUM([Amount]) / 1000, '#,##0.0K')
              , num(SUM([Amount]), '#,##0.0'
    ))))
  , SUM([Amount])
)

You may need to Number formatting option for that field to be Measure Expression for it to show up correctly.

The Dual() function will let you display the field values in specific way, like with custom formatting, but still retain the underlying "pure" numeric value. In your case, it should allow you to display the field values in the custom format you want while still being able to use the underlying "raw" numbers in your nPrinting report.

Upvotes: 0

Related Questions