topic Comparisons with time dimensions in QlikView https://community.qlik.com/t5/QlikView/Comparisons-with-time-dimensions/m-p/418956#M488594 <HTML><HEAD></HEAD><BODY><P>Hello QlikView addicts,</P><P></P><P>I am creating a dashboard where many comparisons are made to the currently selected time dimension.</P><P></P><P>For example the number of POS transactions depending on the time dimension. </P><P></P><P>The time dimensions that I made are Year, Month, yesterday, current week, 4 weeks ago today, today until 8 weeks ago ago and today to 13 weeks ago. In addition the same time dimensions but a year ago. </P><P></P><P>What the customer want is a straight or Pivot table containing for example the number of POS transactions depending on the time dimension with a fields directly next to it the same value of time dimension but compared to last year. </P><P></P><P>I really want to minimize use If statements. </P><P></P><P>Does anyone have another option?</P><P></P><P></P><P>Thanks for your help.</P></BODY></HTML> Sun, 09 Dec 2012 15:20:06 GMT jjordaan 2012-12-09T15:20:06Z Comparisons with time dimensions https://community.qlik.com/t5/QlikView/Comparisons-with-time-dimensions/m-p/418956#M488594 <HTML><HEAD></HEAD><BODY><P>Hello QlikView addicts,</P><P></P><P>I am creating a dashboard where many comparisons are made to the currently selected time dimension.</P><P></P><P>For example the number of POS transactions depending on the time dimension. </P><P></P><P>The time dimensions that I made are Year, Month, yesterday, current week, 4 weeks ago today, today until 8 weeks ago ago and today to 13 weeks ago. In addition the same time dimensions but a year ago. </P><P></P><P>What the customer want is a straight or Pivot table containing for example the number of POS transactions depending on the time dimension with a fields directly next to it the same value of time dimension but compared to last year. </P><P></P><P>I really want to minimize use If statements. </P><P></P><P>Does anyone have another option?</P><P></P><P></P><P>Thanks for your help.</P></BODY></HTML> Sun, 09 Dec 2012 15:20:06 GMT https://community.qlik.com/t5/QlikView/Comparisons-with-time-dimensions/m-p/418956#M488594 jjordaan 2012-12-09T15:20:06Z Re: Comparisons with time dimensions https://community.qlik.com/t5/QlikView/Comparisons-with-time-dimensions/m-p/418957#M488595 <HTML><HEAD></HEAD><BODY><P>Have you tried using <A _jive_internal="true" href="https://community.qlik.com/people/robwunderlich">Rob Wunderlich</A>'s <A href="http://code.google.com/p/qlikview-components/">Qlikview Components</A> library? See his blog post <A href="http://qlikviewnotes.blogspot.nl/2012/01/easy-period-analysis-using-qlikview.html">here</A>. </P></BODY></HTML> Sun, 09 Dec 2012 16:01:19 GMT https://community.qlik.com/t5/QlikView/Comparisons-with-time-dimensions/m-p/418957#M488595 Gysbert_Wassenaar 2012-12-09T16:01:19Z Re: Comparisons with time dimensions https://community.qlik.com/t5/QlikView/Comparisons-with-time-dimensions/m-p/418958#M488596 <HTML><HEAD></HEAD><BODY><P>Gysbert,</P><P></P><P>Ik heb dit geprobeerd.</P><P>Misschien ben ik wat eigenwijs maar ik wil (met behulp van mensen met meer ervaring) graag zelf ontwikkelen omdat ik zo ook blijf begrijpen hoe alles opgezet is.</P></BODY></HTML> Sun, 09 Dec 2012 16:08:52 GMT https://community.qlik.com/t5/QlikView/Comparisons-with-time-dimensions/m-p/418958#M488596 jjordaan 2012-12-09T16:08:52Z Re: Comparisons with time dimensions https://community.qlik.com/t5/QlikView/Comparisons-with-time-dimensions/m-p/418959#M488597 <HTML><HEAD></HEAD><BODY><P>Gysbert,</P><P></P><P>I also could not find on example / solution for my problem.</P></BODY></HTML> Sun, 09 Dec 2012 16:26:34 GMT https://community.qlik.com/t5/QlikView/Comparisons-with-time-dimensions/m-p/418959#M488597 jjordaan 2012-12-09T16:26:34Z