Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
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 .