Discussion board where members can get started with Qlik Sense.
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
You can use Rangesum() with Above() functions to achieve this. Share some sample data to work on.
Please find the sample data.
i need to implement this requirement in KPI object .