topic Max Date and Max Day Variable in QlikView

Max Date and Max Day Variable

rido1421 — Wed, 14 Jan 2015 08:21:20 GMT

Hi There

I would like to create a variable for max(Day) and Max(Year)

I have a dashboard and I have the current year sales figures

I also have last year sales figures I want to compare the two YTD so in my set analysis of the previous year I want to use a variable

to tell it to give me the sales figures for last year but only up until this years Max(Day)

what is the best way to do this?

I hope this makes sense...

Regards

Gysbert_Wassenaar — Wed, 14 Jan 2015 09:06:35 GMT

Create a variable vMaxDay as =max(Day) and a variable vMaxYear as =max(Year).

You can use these variables in set analysis expressions.

Current: sum(Amount)

Previous year: sum({<Year={$(=vMaxYear-1)},Day={'<=$(=vMaxDay-1)'}>} Amount)

rido1421 — Wed, 14 Jan 2015 09:45:49 GMT

I have used =(Day(today()-1)) as my variable vCurrentDay and then used this in my set analysis

seems to work well... do you see any Issues I may have from doing it this way Gysbert?