Rolling Month / Quarter ...............

[#1]

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.

[mantaq10]

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)