Filtering on day by day comparsion

btrompetter — Tue, 05 Jan 2010 15:01:30 GMT

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

Filtering on day by day comparsion

Fri, 25 Jun 2010 14:33:51 GMT

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

topic Filtering on day by day comparsion in QlikView

Filtering on day by day comparsion

Filtering on day by day comparsion