Last week vs this week comparison

[Anonymous]

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 · Accepted solution]

Hi,

On dim1, if you try

=WeekDay(TransactionDate)

[Anonymous]

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]

both solutions are working , thanks Robin and Aurelien