Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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))))
first, thank you for your answer, but still not working, continues to show null