Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
abubakarsiddiq7
New Contributor

how to sum up values based on filter selection

hi Team,

i have month filter which is having values like Jan,Feb,......Dec.

my requirement is when i select 

feb then my sum(sales) my output should be  Jan month sales +feb month sales.

mar ---then  my sum(sales) my output should be  Jan month sales +feb month sales + month sales.mar 

Dec--->Jan+feb+mar+apr...............Nov+dec month sales.

 

Thanks in Advance 

 

2 Replies
vishsaggi
Esteemed Contributor III

Re: how to sum up values based on filter selection

You can use Rangesum() with Above() functions to achieve this. Share some sample data to work on.

abubakarsiddiq7
New Contributor

Re: how to sum up values based on filter selection

HI ,

Please find the sample data.

i need to implement this requirement in KPI object .