Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding Totals

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,

1 Solution

Accepted Solutions
sunny_talwar

This I guess:

=Sum(TOTAL <Year> Ammount)

View solution in original post

3 Replies
sunny_talwar

This I guess:

=Sum(TOTAL <Year> Ammount)

Not applicable
Author

thanks alot

sunny_talwar

No problem