Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 ....