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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
adeagts
Contributor
Contributor

RangeSum with Multiple Dimension

Hello,

I was create pivot table with 3 dimensions (MonthName(Date), Date, ProductGroup). I was create RangeSum with special conditions to see acummulation balance. When i collapsed Date to be MonthName(Date), acummulation balance is showed correct calculation, when i expanded only one month to see Daily balance, the acummulation balance is still showed correct calculation. But when i filtered 2 value in ProductGroup (ex: FA8 and FA8/99), the accumulation showed incorrect number. The end balance accumulation show number FA8+FA8/99. I want the pivot table show partial end balance accumulation (EndT). Please help me?

 

adeagts_0-1733709312369.png

 

 

Labels (6)
1 Reply
adeagts
Contributor
Contributor
Author

The formula of EndT is (Beg + Prod FG - CO FG - CO FGP), and accumulation for all month is showed.

The EndT at FA8 is correct. But EndT at FA8/99 is EndT of FA8 plus EndT actual of FA8/99 EndT. EndT of FA8/99 should be 927.