Comparisons with time dimensions

[jjordaan]

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.

[Gysbert_Wassenaar · Accepted solution]

Have you tried using Rob Wunderlich's Qlikview Components library? See his blog post here.

[jjordaan]

Gysbert,

Ik heb dit geprobeerd.

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.

[jjordaan]

Gysbert,

I also could not find on example / solution for my problem.