topic Calculated Dimension Help in QlikView

Calculated Dimension Help

samvile18 — Fri, 25 Mar 2011 09:25:48 GMT

Hi Guys,

Can anyone help with the following problem please?

I have a list of week numbers in the following format Week1, Week2, Week3 etc....I'm currently up to week 13.

What I want to do is create a calculated dimension that looks at the latest week only....so in this case it would bring back Week13, everything I've tried just isn't working.

Any help is greatly appreciated.

Calculated Dimension Help

pljsoftware — Fri, 25 Mar 2011 09:40:35 GMT

Hello,

would you like to select only a week? I have not understand your problem. Can you explain it with an if syntax expression?

Calculated Dimension Help

samvile18 — Fri, 25 Mar 2011 09:47:54 GMT

Yes...I basically only want to select the latest week of data. I'm trying to create some gauges that only report on the latest weeks worth of data...in this case they would be reporting on week13....whereas next week it would move on to week14 etc.

Calculated Dimension Help

pljsoftware — Fri, 25 Mar 2011 11:44:44 GMT

Hi Sam,

you can create a variable with the value of maxdate and use this variable to take only the products of the last week.

Example:
If your variable is vEndDate and your date field is Date you can write this formula in your gauge chart

if( Date>(vEndDate-7), sum(Qty))

This only if you want to calculate always the value of the last 7 days.

Regards
Luca

Calculated Dimension Help

suniljain — Fri, 25 Mar 2011 11:47:31 GMT

if(WEEK = Max(Week),WEEK)

If want summation of amount

Sum(if(WEEK = Max(Week),Amt))