topic Rolling 3 months in QlikView

Rolling 3 months

its_anandrjs — Wed, 22 Jun 2011 13:08:05 GMT

Hi All,

How to show Rolling 3 months in X-axis and if i select Jun-09 it should display Apr-09,May-09,Jun-09 in x-axis like ways it should be work on all dates like current date also.

Anand

Rolling 3 months

Wed, 22 Jun 2011 18:43:50 GMT

Have you tried using set analysis?

Current Month:

Sum({$<[month]={$(=max([month]))}>} [Net Revenue])

for last month:

Sum({$<[month]={$(=max([month])-1)}>} [Net Revenue])

Rolling 3 months

its_anandrjs — Thu, 23 Jun 2011 09:26:19 GMT

I have this type of data please explain for that with any qvw file.

Month, Sales

Jan-09, 55

Feb-09, 39

Mar-09, 33

Apr-09, 56

May-09, 55

Jun-09, 70

Jul-09, 57

Aug-09, 29

Sep-09, 34

Oct-09, 41

Nov-09, 12

Dec-09, 11

Jan-10, 24

Feb-10, 85

Mar-10, 99

Apr-10, 77

May-10, 85

Jun-10, 64

Jul-10, 61

Aug-10, 45

Sep-10, 62

Oct-10, 70

Nov-10, 59

Dec-10, 25

Jan-11, 86

Feb-11, 92

Mar-11, 67

Apr-11, 65

May-11, 39

Jun-11, 70

Rolling 3 months

Thu, 23 Jun 2011 17:58:35 GMT

Create a listbox with Month in it, then create a chart with Month as the dimension. Then create the following 3 expressions:

Current Month:Sum({$<[Month]={$(=max([Month]))}>} [Sales])

One Month Back: Sum({$<[Month]={$(=max([Month])-1)}>} [Sales])

Two Months Back: Sum({$<[Month]={$(=max([Month])-2)}>} [Sales])

Now select any month from your list box and the expressions above will give you that months sales plus the two prior months.