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

Sun, 10 Oct 2010 16:53:20 GMT

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.

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

mantaq10 — Sun, 10 Oct 2010 20:39:40 GMT

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)

topic Rolling Month / Quarter ............... in QlikView

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

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