topic Re: results compare with 2 different time periode in QlikView https://community.qlik.com/t5/QlikView/results-compare-with-2-different-time-periode/m-p/381103#M142184 <HTML><HEAD></HEAD><BODY><P>The case you're referreing to most likely doesn't work for you because of the date fields and variables formatting.&nbsp; Make sure that the same format is used in all fields and variables you use in the set expression.</P><P>An example wil be of no use if the data format is different in your case.</P><P></P><P>Regards,</P><P>Michael</P></BODY></HTML> Tue, 28 Aug 2012 14:31:42 GMT Anonymous 2012-08-28T14:31:42Z results compare with 2 different time periode https://community.qlik.com/t5/QlikView/results-compare-with-2-different-time-periode/m-p/381098#M142179 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have a case here,</P><P>I want to compare a result between 2 randomly different period,</P><P>example : </P><P>1st periode : jun - july 2011</P><P>2nd periode : jan - feb 2012</P><P></P><P>has anyone had this case before? </P><P>thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="45" style="width: 904px; border: 1px solid #000000; height: 30px;"><TBODY></TBODY></TABLE></BODY></HTML> Mon, 27 Aug 2012 10:43:06 GMT https://community.qlik.com/t5/QlikView/results-compare-with-2-different-time-periode/m-p/381098#M142179 2012-08-27T10:43:06Z Re: results compare with 2 different time periode https://community.qlik.com/t5/QlikView/results-compare-with-2-different-time-periode/m-p/381099#M142180 <HTML><HEAD></HEAD><BODY><P>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.</P><P>The selected time period expression simple, e.g. sum(Amount).</P><P>The second expression will be using set analysis where set "moves" time N months back or forward.&nbsp; </P><P>I use slider to change the shift from -24 to +24 months, that is up to one year back or forward.&nbsp; Certainly you must keep the data in application for all this time range.</P><P></P><P>Another approach is using Alternate Set.&nbsp; I think it is simpler.</P><P></P><P>Regards,</P><P>Michael</P></BODY></HTML> Tue, 28 Aug 2012 01:53:35 GMT https://community.qlik.com/t5/QlikView/results-compare-with-2-different-time-periode/m-p/381099#M142180 Anonymous 2012-08-28T01:53:35Z Re: results compare with 2 different time periode https://community.qlik.com/t5/QlikView/results-compare-with-2-different-time-periode/m-p/381100#M142181 <HTML><HEAD></HEAD><BODY><P>Thanks Michael, but in this case the two periode possible have different length of month.</P><P>Do you have any qlikview sample?</P></BODY></HTML> Tue, 28 Aug 2012 07:41:55 GMT https://community.qlik.com/t5/QlikView/results-compare-with-2-different-time-periode/m-p/381100#M142181 2012-08-28T07:41:55Z Re: results compare with 2 different time periode https://community.qlik.com/t5/QlikView/results-compare-with-2-different-time-periode/m-p/381101#M142182 <HTML><HEAD></HEAD><BODY><P>With the possiblity of the different lengths, use Alternate Set approach.&nbsp; That is, separate independent selections in the same field, and separate expressions.</P><P>See example "what's new in QV 11" in "Getting started".</P><P></P><P>Regards,</P><P>Michael</P></BODY></HTML> Tue, 28 Aug 2012 10:12:12 GMT https://community.qlik.com/t5/QlikView/results-compare-with-2-different-time-periode/m-p/381101#M142182 Anonymous 2012-08-28T10:12:12Z Re: results compare with 2 different time periode https://community.qlik.com/t5/QlikView/results-compare-with-2-different-time-periode/m-p/381102#M142183 <HTML><HEAD></HEAD><BODY><P>i'm using QV 10 actually, </P><P>actually my case similar with <A _jive_internal="true" class="loading" href="https://community.qlik.com/message/153610">http://community.qlik.com/message/153610</A>,</P><P>but still my result seems wrong, could anyone give me a sample.</P><P>Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Tue, 28 Aug 2012 12:52:10 GMT https://community.qlik.com/t5/QlikView/results-compare-with-2-different-time-periode/m-p/381102#M142183 2012-08-28T12:52:10Z Re: results compare with 2 different time periode https://community.qlik.com/t5/QlikView/results-compare-with-2-different-time-periode/m-p/381103#M142184 <HTML><HEAD></HEAD><BODY><P>The case you're referreing to most likely doesn't work for you because of the date fields and variables formatting.&nbsp; Make sure that the same format is used in all fields and variables you use in the set expression.</P><P>An example wil be of no use if the data format is different in your case.</P><P></P><P>Regards,</P><P>Michael</P></BODY></HTML> Tue, 28 Aug 2012 14:31:42 GMT https://community.qlik.com/t5/QlikView/results-compare-with-2-different-time-periode/m-p/381103#M142184 Anonymous 2012-08-28T14:31:42Z