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

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

Aggregate function

sum(ValueINR) is not working correctly in pivot table

sum(valueINR is 1000000

but it show 40000 its column wise

10 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

     Add straight table with dimension as region, and expression as Sum((Value INR) / sum( total (Value INR)

     Have a look at the attched file.

     

Regards,

Kaushik Solanki    

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!