Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Jsobrinho77
Creator
Creator

Cumulative values pivot table error

Hi guys,

Could you please help to do cumulative values in Qliksense pivot table? I don't understand why for some dimension the cumulative not working

 

Labels (4)
2 Replies
Anil_Babu_Samineni

@Jsobrinho77 Perhaps with this TOTAL qualifier?

sum({<quarter_={"<=8"},[Info]={'V'},[Flag]={'e'},[Year],[Period],Month,Quarter>}
aggr(RangeSum(Above(Sum({<[Info]={'V'},[Flag]={'e'},[Year],[Period],Month,Quarter>} Value),0,RowNo(TOTAL)))
,Dimension,[Year],[Dimension2],(Quarter,(NUMERIC, ASCENDING))))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Jsobrinho77
Creator
Creator
Author

first, thank you for your answer, but still not working, continues to show null