Comparing Values Between Multiple Dates

[LukeCraven36]

Good day Qlik Experts,

This is my very first post to the Community .. I imagine there will be many more as I progress with Qlik Sense.

I'm using the following set analysis to compare week on week (or day on day) values:

(sum([Sales (£)])
-
sum( {< [Date] = {"$(=Date((Date)-7,'DD/MM/YYYY'))"} >} [Sales (£)]))

This works perfectly when selecting just one date

However, if I select multiple dates, then the set analysis fails.

I need your help .. how can I have the week on week work when I select multiple dates?

Thanks in advance

[TimvB]

Hi, welcome to the Qlik Community!

In case you select multiple dates, your set analysis expression does not know from which date to substract one week (7 days). Therefore, you should specify a single date in the set analysis, for example, the minimum date of the selected dates. In this case, the expression is:

sum([Sales (£)])
-
sum({< [Date] = {"$(=Date(Min(Date)-7,'DD/MM/YYYY'))"} >} [Sales (£)])

I would recommend to visualize the "current day" and "previous day" somewhere on the dashboard so that users do not get confused. This can for example be done in a text object or just as a subtitle or footnote of the KPI.

Hope it helps!

[LukeCraven36]

Hi Tim,

Thank you for help/reply .. really appreciate it. So, if I give you an example, could you tell me if this would work. Previously, I did have MAX (where you’ve added MIN)  and although the KPI showed a value, it wouldn’t reflect what I was after. For example (using MAX):

I’d select Sun 23/02/2020 and it would compare it to Sun 16/02/2020 .. a week on week comparison of Sunday. Great. However if I select 23/02 and 22/02 then this is where it fails. I’d be comparing the Sat and Sun (current week) to only Sun (previous week) as it would be searching for my MAX value only in the current week. 

It’s asking Qlik to compare multiple dates in the previous week if selected. 

Hope this makes sense?