3 Replies Latest reply: Dec 9, 2012 11:26 AM by Jeroen Jordaan RSS

    Comparisons with time dimensions

    Jeroen Jordaan

      Hello QlikView addicts,

       

      I am creating a dashboard where many comparisons are made to the currently selected time dimension.

       

      For example the number of POS transactions depending on the time dimension.

       

      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.

       

      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.

       

      I really want to minimize use If statements.

       

      Does anyone have another option?

       

       

      Thanks for your help.