Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
its_anandrjs

Rolling 3 months

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

3 Replies
Not applicable

Have you tried using set analysis?

Current Month:

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

for last month:

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

its_anandrjs
Author

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

Not applicable

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.