Failed visualization of values in charts

[Marta4]

Hi, 

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

- Either no values are displayed in the chart ( all 0). 

- Only values related to one field ( the rest appear as 0).

However, when I right click on the chart in the power point 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 round 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!

[Ruggero_Piccoli]

Hi,

Please remember to add the label with the correct version you are using. The answer could depends on it. 

When you open the Excel file related to the chart are the data in columns included in the area used by the chart? 

Are there data on it?

Having screenshots will help to try to reproduce here.

Best Regards,

Ruggero

[Marta4]

Hi Ruggero, 

thanks for your answer. 

The Nprinting version I am using is 22.15.14.0

Sample of the excel that I get when I right click and edit in power point chart is this one: 

sample of the chart when I convert the report in power point is this one: 

So it seems that only data in the first column is correctly displayed.

Best, 

Marta

[Lech_Miszkiewicz · Accepted solution]

The issue is that your formula results in values which cannot be interpreted by powerpoint as numbers hence chart is not showing them. If your cell have values like 23M or 31K those are treated as text (which is normal in excel and powerpoint) and your chart will not work.

the workaround is to create dedicated chart in Qlik Sense with standard number format which can be exported as number and interpreted as number.

cheers

[Lech_Miszkiewicz]

By the way. 
you can see that those values are treated as text as those are left aligned in cells 

[Marta4]

Thanks for your answer!

Are there any other workarounds?

I have already created charts directly in Qliksense usying the auto formatting number option ( 1M, 1.3B etc...) and exported them in Nprinting, but the format is not maintained in Nprinting even if I click on keep source format in the properties panel.  

[Lech_Miszkiewicz]

Formatting it in Qlik does not make sense in this case. I would just export numbers without any “fancy” conditional formatting. 
you could then use chart number formatting on the labels directly in Power Point using Power Point features