Discussion board where members can get started with QlikView.
I want to make Balance Sheet on qlikview. But BS must be cumulative, not be single month.
Not like this. Because jan is correct but feb and the other months is montly, must be cumulative.
It must be like this.
Could you please help me?
Yes, you are right, if you use pivot table, I think you can use this :
View solution in original post
rangesum( above( sum([Tutar (UPB3)]),0,12) )
This formula is true when months on row but when put it on column, it is not true.
Actually in Chart Properties, there is a function - Accumulation.
You can try to use Full Accumulation. And for expression, just use sum() is ok.
Please try, thanks.
Thanks Aiolos, but this is not for pivot or straight table.
When choose pivot table, this property is deactive.
Thanks Aiolos, it works
what is [Tutar (UPB3)]???