topic Re: Last week vs this week comparison in QlikView

Last week vs this week comparison

Anonymous — Fri, 04 Nov 2016 11:57:39 GMT

I have a requirement to draw the last week and this week consumption value based on Monday to Sunday.

My expression for this week is

(sum({<TransactionDate={"=inweek(TransactionDate,today(1),0)"}>}E10)

My expression for last week is

(sum({<TransactionDate={"=inweek(TransactionDate,today(1),-1)"}>}E10)

Can i get some help in consolidating like instead of what is shown in my screenshot?

--------------------------------------------------------------------

This Week Last Week

Monday 25.23 24.09

Tues 32.11 31.9

Aurelien_Martinez — Fri, 04 Nov 2016 16:27:12 GMT

Hi,

On dim1, if you try

=WeekDay(TransactionDate)

Anonymous — Fri, 04 Nov 2016 16:34:40 GMT

This can't work because you just change the text representation.

QlikView uses the number behind the text.

You could force it like that:

=text(Date([Transaction Date],'WWW'))

Anonymous — Fri, 04 Nov 2016 23:08:15 GMT

both solutions are working , thanks Robin and Aurelien