topic Adding Totals in QlikView

Adding Totals

Thu, 12 Nov 2015 16:47:19 GMT

Hello.

I was wondering if anyone knows how i can use the set analysis so i can turn and expresion like sum(TOTAL Ammount), to add the total but only of the year of the dimension.

Its something like sum({$<Year={'2013'}>} TOTAL Ammount), but i want to total of each year on the dimension.

pls help,

thanks,

Re: Adding Totals

sunny_talwar — Thu, 12 Nov 2015 16:48:14 GMT

This I guess:

=Sum(TOTAL <Year> Ammount)

Re: Adding Totals

Thu, 12 Nov 2015 16:51:22 GMT

thanks alot

Re: Adding Totals

sunny_talwar — Thu, 12 Nov 2015 16:52:59 GMT

No problem