topic Re: compare set of rolling months in QlikView

compare set of rolling months

Wed, 16 Apr 2014 10:26:08 GMT

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
2011	2012	2013	2014

months
jan	feb	mar	apr	may	jun	jul	ago	sep	oct	nov	dec

	sales
	jan '14	feb '14	mar '14	dec '13	jan '14	feb '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?

Re: compare set of rolling months

Wed, 16 Apr 2014 10:51:58 GMT

Simple example for you.

I hope, that it halps.

regards

Darek

Re: compare set of rolling months

Wed, 16 Apr 2014 12:57:40 GMT

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!

Re: compare set of rolling months

Wed, 16 Apr 2014 13:02:09 GMT

What do you need more?

Re: compare set of rolling months

Wed, 16 Apr 2014 13:06:32 GMT

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....

Re: compare set of rolling months

Wed, 16 Apr 2014 13:07:10 GMT

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

Re: Re: compare set of rolling months

Wed, 16 Apr 2014 13:12:46 GMT

next examle

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

regards

Darek

Re: compare set of rolling months

Wed, 16 Apr 2014 13:13:04 GMT

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...

Re: Re: compare set of rolling months

Wed, 16 Apr 2014 13:16:39 GMT

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

Re: compare set of rolling months

Wed, 16 Apr 2014 13:21:07 GMT

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

Re: compare set of rolling months

Wed, 16 Apr 2014 13:27:11 GMT

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

Re: Re: compare set of rolling months

Wed, 16 Apr 2014 14:12:52 GMT

aha ...

Re: Re: compare set of rolling months

Wed, 16 Apr 2014 14:23:40 GMT

Let me know if you like my v2 example

Re: Re: compare set of rolling months

Wed, 16 Apr 2014 14:31:49 GMT

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

Re: Re: compare set of rolling months

Wed, 16 Apr 2014 14:49:07 GMT

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

Re: Re: Re: compare set of rolling months

Wed, 16 Apr 2014 16:10:36 GMT

A little bit optimised ....