how to calculate result difference from average previous 4 week same weekday results

trevorkr — Fri, 10 Aug 2018 09:20:39 GMT

Hello

I am trying to create a KPI that would show me the difference of filtered dates' result against the selected dates same weekdays results, looking back only 4 weeks (29 days) from filtered date.

For example, if I were to select 09.08.2018 from filter then the KPI would show me the percentage of how much different the selected dates result is compared to last 4 weeks same weekdays average result.

I tried to create an expression but it is not limiting the selection to 4 weeks.

(

Sum(

{

TYPE={'10'},

CurYTDFlag={1},

PPR_TYPEID={'1','2','3'}

}

RESULT

))

(Only(

Aggr(

Sum

(

Total

WeekDay

RESULT)

count(

Total

WeekDay

DISTINCT DB_KPI_DATE),

WeekDay,

DB_KPI_DATE)))

-1

Can any one please help

Re: how to calculate result difference from average previous 4 week same weekday results

sunny_talwar — Fri, 10 Aug 2018 16:12:44 GMT

Are you doing this in a text box object? Also, it would be easier to make sense of this if you can share a sample app to look at...

topic how to calculate result difference from average previous 4 week same weekday results in QlikView

how to calculate result difference from average previous 4 week same weekday results

Re: how to calculate result difference from average previous 4 week same weekday results