Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
samvile18
Contributor II

Calculated Dimension Help

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.

4 Replies
pljsoftware
Contributor III

Calculated Dimension Help

Hello,

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

samvile18
Contributor II

Calculated Dimension Help

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.

pljsoftware
Contributor III

Calculated Dimension Help

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

suniljain
Honored Contributor

Calculated Dimension Help

if(WEEK = Max(Week),WEEK)

OR

If want summation of amount

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