Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

What Data format is needed to get correct percent values in Pivot table chart.

Hi,

I have used this below given formula to calculate the percent and added the field as expression in pivot table.

margin/Freight *100 as GM%

So, the calculation is correct for some values only.

The format used is integer and expression is sum(GM%).

PFA screenshot of my pivot where I've marked the wrong values in red and right ones in green.

Thanks

11 Replies
Anonymous
Not applicable
Author

pls check attached file

Anonymous
Not applicable
Author

sum(margin)/ sum(freight) worked in chart expression but not in script, why so?

Anyway, thanks as this worked for the current need.