topic Display current and previous total regarding selection made for ‘Date’ dimension in QlikView

Display current and previous total regarding selection made for ‘Date’ dimension

Thu, 09 Feb 2012 17:49:48 GMT

Dears,

I need help for a very BASIC need !

I have one dimension 'Date' which corresponds to LOAD Date for several sources files.

I just want to display the current TOTAL regarding selection made for ‘Date’ dimension and the total for the previous day available in the list BUT NOT REGARDING THE PREVIOUS SELECTION MADE (i.e set analysis functions), which is different.

As you can see (enclosed and here below), I have for instance 01/23/2012 as Day and previous day is 01/20/2012.......How can I automatically gather previous day available........

Thanks a lot, Michaël.

Display current and previous total regarding selection made for ‘Date’ dimension

pover — Thu, 09 Feb 2012 18:08:55 GMT

Michaël,

Try the following expression:

if([Total Delta MT]=0.00,'-', Sum({$<BibleDate={'$(=max({1<BibleDate={"<$(=max(BibleDate))"}>} BibleDate))'}>} [Total Delta MT]))

The tricky part of the expression is finding the previous day since the previous day is not always 1 day less than the day selected so that's why you have to do the nexted set analysis to find the previous day.

Karl

Display current and previous total regarding selection made for ‘Date’ dimension

Fri, 10 Feb 2012 13:38:38 GMT

Dear Karl,

Thanks a lot for this effective response.

If I want to store in a variable vPreviousDay this ‘Previous’ value,

How can I deal with syntax?

Directly this: {$<BibleDate={'$(=max({1<BibleDate={"<$(=max(BibleDate))"}>} BibleDate))'}>} ?

Michaël.

Display current and previous total regarding selection made for ‘Date’ dimension

pover — Fri, 10 Feb 2012 16:44:24 GMT

In the vPreviousDay variable put {$<BibleDate={'$(=max({1<BibleDate={"<$(=max(BibleDate))"}>} BibleDate))'}>} without an equal sign and then your expression will be:

if([Total Delta MT]=0.00,'-', Sum($(vPreviousDay) [Total Delta MT]))

Karl

Display current and previous total regarding selection made for ‘Date’ dimension

Fri, 10 Feb 2012 18:21:38 GMT

Thanks Karl as usual!

Display current and previous total regarding selection made for ‘Date’ dimension

Thu, 16 Feb 2012 16:12:36 GMT

Dear Karl,

You gave me a good input to display the previous TOTAL for the previsus 'Date' available as following:

In the vPreviousDay variable put

{$<BibleDate={'$(=max({1<BibleDate={"<$(=max(BibleDate))"}>} BibleDate))'}>} without an equal sign and then your expression will be:

if([Total Delta MT]=0.00,'-', Sum($(vPreviousDay) [Total Delta MT]))

But........how can I deal with [Date - 2], [Date - 3], [Date - 4] values as per schema here below????

Thanks in advance,

Michaël