% change in Expression, Week over Week

Mon, 08 Aug 2016 19:00:24 GMT

Hello,

I am looking to write an expression in Qlikview showing a percent change comparing a week over week. I would like my weeks to be:

Current Week-1

and

Current Week-2

My current expression is

=Num(Sum(DISTINCT{1<Date = {"$(='>=' & Date(WeekStart(Max(Date),-1), 'M/D/YYYY') & '<=' & Date(WeekEnd(Max(Date),-1), 'M/D/YYYY'))"}, [Workload Type] = {'Referral'},[Channel]={'Self Service'}, Week, Year>} Count)
/
Num(Sum(DISTINCT{1<Date = {"$(='>=' & Date(WeekStart(Max(Date), -2), 'M/D/YYYY') & '<=' & Date(WeekEnd(Max(Date), -2), 'M/D/YYYY'))"}, [Workload Type] = {'Referral'}, [Channel]={'Self Service'}, Week, Year>} Count)) - 1
,'▲ 0.0%;▼ 0.0%')

However, this is NOT following a percent change formula where: (New Value-Old Value)/Old Value.

Can you help me modify the current expression to meet our needs?

Re: % change in Expression, Week over Week

swuehl — Mon, 08 Aug 2016 19:56:43 GMT

I think it's folloiwing

New / Old - 1

Isn't this mathematical equivalent to (New - Old) / Old ?

topic Re: % change in Expression, Week over Week in QlikView

% change in Expression, Week over Week

Re: % change in Expression, Week over Week