topic Sum and Percentage Diff Between Two Max Dates Within Range in App Development

Sum and Percentage Diff Between Two Max Dates Within Range

Anonymous — Thu, 10 Aug 2017 09:50:48 GMT

Hello Qlik Community,

In a nutshell I have 5 week ending dates as a dimension. From these 5 week ending dates (Friday) I want to select the latest 2 within the range and calculate the sum difference between them and also the percentage difference as two separate KPI's.

I've had a look online at other topics but I'm finding it difficult to apply the logic to my specific example.

Thanks for any help

Re: Sum and Percentage Diff Between Two Max Dates Within Range

dan_sullivan — Thu, 10 Aug 2017 15:28:28 GMT

depending on how your data model looks, you should look into using FirstSortedValue to help identify the two dates that you need.

Alternatively you could create a rank variable, then reference the rank variable in set analysis to isolate each one.

Re: Sum and Percentage Diff Between Two Max Dates Within Range

Anonymous — Tue, 22 Aug 2017 09:21:29 GMT

Hi Dan

Just an update on what I managed to do.

LET vLW = floor(now()-num(weekday(now())))-3;

LET vLWW = floor(now()-num(weekday(now())))-10;

LET vLWWW = floor(now()-num(weekday(now())))-17;

LET vLWWWW = floor(now()-num(weekday(now())))-24;

LET vLYW = floor(addyears(now(),-1))-num(weekday(addyears(now(),-1)))-3;

The above should get to the last 4 weeks worth of week ending dates and also the latest weeks last year equivalent.