Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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?

15 Replies
Not applicable
Author

hopefully this will help...sorry for not being clear enough...

Not applicable
Author

aha ...

Not applicable
Author

Let me know if you like my v2 example

Not applicable
Author

you rock man!!!!! thank you so much!!!! really helpfull!!! that's what I was looking for!!!

Not applicable
Author

I would like to be able to do similar things with my income in a bank account

Not applicable
Author

A little bit optimised ....