Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello and happy New Year,
we want to create a dashboard like this one:
The table should show a day by day comparsion beween the current year and the last year. But it should only compare a monday with a monday depending an the leap year. Is this possible with QlikView and also have the dynamic filtering function?
Or is the overhead to implement this function to big, that it's better to create a fixed formular which only compares one day?
regards
Bastian
Hi Bastian,
I've added the following condition to my sets in order to display do day/day and monday vs. monday comparisons:
[Date] = {"$(=date(today()-1))"}
[Date] = {"$(=date(today()-7))"}
The first query returns the previous day and the second query data for 7 days prior.
Hope that helps,
Matt