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: 
Anonymous
Not applicable

Sum of sales based on List box selection

Hi folks,

I have following requirement.

i have one list box for Month field.. i have expression for sum(sales) . if no month selected i need to show 12 months total sales. and if i selected april month i need to sum sales upto april..(Sum(sales)for jan feb march april(accumulation))..how can i do this...

Thanks in Advance..

Regards,

Venkat.

11 Replies
kushalthakral
Creator III
Creator III

sum({<Month={'<=$(=Max(Month))'}>} Sales)

Anonymous
Not applicable
Author

Thanks Neetha...for ur explanation....