results compare with 2 different time periode

[#1]

Hi all,

I have a case here,

I want to compare a result between 2 randomly different period,

example :

1st periode : jun - july 2011

2nd periode : jan - feb 2012

has anyone had this case before?

thanks

[Anonymous]

If the periods to compare are always equal in length (two months vs. two months in your example; can be any N month vs. N month) - it is possible with set analysis.

The selected time period expression simple, e.g. sum(Amount).

The second expression will be using set analysis where set "moves" time N months back or forward. 

I use slider to change the shift from -24 to +24 months, that is up to one year back or forward.  Certainly you must keep the data in application for all this time range.

Another approach is using Alternate Set.  I think it is simpler.

Regards,

Michael

[#3]

Thanks Michael, but in this case the two periode possible have different length of month.

Do you have any qlikview sample?

[Anonymous]

With the possiblity of the different lengths, use Alternate Set approach.  That is, separate independent selections in the same field, and separate expressions.

See example "what's new in QV 11" in "Getting started".

Regards,

Michael

[#5]

i'm using QV 10 actually,

actually my case similar with http://community.qlik.com/message/153610,

but still my result seems wrong, could anyone give me a sample.

Thanks

[Anonymous]

The case you're referreing to most likely doesn't work for you because of the date fields and variables formatting.  Make sure that the same format is used in all fields and variables you use in the set expression.

An example wil be of no use if the data format is different in your case.

Regards,

Michael