topic Re: Trial balance in QlikView

Trial balance

stephane_kosior — Wed, 23 Aug 2017 15:32:11 GMT

Hi,

I'm trying to create a Pivot Chart with QV where I can build a trial balance by month

I have set the expression like this :

sum({<[Account Type]={'BS'},[Fiscal Year]={$(vYTDYear)}>} [Amount])

But I would like that the October column will sum the september column and the "activity" done in October. I tried the above function but without any success.

Could you please help me ?

Re: Trial balance

sunny_talwar — Wed, 23 Aug 2017 15:38:46 GMT

Since this is a pivot table... try using Before instead of Above

Missing Manual - Before() and After()

Re: Trial balance

stephane_kosior — Wed, 23 Aug 2017 15:49:46 GMT

Many thanks Sunny Talwar.

It works fine ! I wan't aware of this function ... and I should !!

Many thanks again.