Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have created a rolling month using Set Analysis . But when I click on the Quarter and select the month june , Its only displaying the value of the month june . What I want is when I qlik on Quarter 2 and select the month june , it has to display the cummulative values from Jan to June .
To be more clear , If clik on Quarter 2 , it has to display the values of Quarter1 + Quarter2 , if I clik on Quarter 3 , it has to display the vales Quarter1 + Quarter2 + Quarter 3 .
I dont have a date column to use the addmonth functions and achieve it .
I have gone through some of the examples in the forum . But i didnot helped me .
I request your help...
Regards,
Chakravarthy.
One way to do this would be to create a field during load
right(Quarter,1) as Quarter_Number
and then aggregating using set analysis like this:
=sum({<Quarter_Number = {"<=$(=right(Quarter,1))"}>}Value)