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: 
Not applicable

compare set of rolling months

I would like to compare a set of month with the same set of month -1.

ie. if I highlight the months Jan2014-Feb2014-March 2014, I would like to have a column next to the previous where I have the sales value of Dec2013-Jan2014-Feb2014.

Year
2011201220132014
months
janfebmaraprmayjunjulago sepoctnov dec

sales
jan '14feb '14mar '14dec '13jan '14feb '14
client
client
client
client
client
client

if I highlight 5 months I'll have the comparison Jan'14/Feb '14/Mar '14/Apr '14/May '14 VS Dec '13/Jan'14/Feb '14/Mar '14/Apr '14 and so on...it is possible (and if yes, how) to do it through set analysis or I need to write a macro?

1 Solution

Accepted Solutions
Not applicable
Author

15 Replies
Not applicable
Author

Simple example for you.

I hope, that it halps.

regards

Darek

Not applicable
Author

Thank you Dariusz Mielczarek...it's half way of what I need though, and I have actually already found something like that in the community...I was hoping for the complete solution. But thanks anyway for answering me!

Not applicable
Author

What do you need more?

Not applicable
Author

I need the comparison with the same number of months that I select -1.

So I select Jan2014-Feb2014-March 2014 I would like to see at the same time Dec2013-Jan2014-Feb2014 and so on...if I select 6 months Jan'14/Feb '14/Mar '14/Apr '14/May '14/Jun '14 I want to see also Dec '13/Jan'14/Feb '14/Mar '14/Apr '14/May '14....

Not applicable
Author

Maybe you simple dont need DIM_MONTH in your chart dimension?

It will then present result for all months:

for example if you select:

Jan2014-Feb2014-March 2014

then you will have sum of sales for those 3 months as CURR

And sum of sales for Dec2013-Jan2014-Feb2014 as PREV

Not applicable
Author

next examle

if it is not you need, please do xls showing chart you like to have

regards

Darek

Not applicable
Author

I don't think...I need that variable! I want to see each month in both periods. at the moment the best thing I could find in the community is this:

Month on Month analysis

but the comparison it's between the same months from different years...

Not applicable
Author

In my first example you have dimension: DIM_MONTH

But for each month you have 2 values:

- this month value

- prev month value

So, for 1-2014 under CURR you have sale (1-2014) but under PREV you have sale (12-2013), etc

Not applicable
Author

Please select come customer, and then look on values in straight table ....