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

Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here
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

Labels (1)
10 Replies
kaushiknsolanki
MVP
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!