Display current, previous, Minus 2 values, minus 3 values total regarding selection made for ‘Date’ dimension.

Thu, 16 Feb 2012 16:11:44 GMT

Dear all,

Karl gave me an 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.

topic Display current, previous, Minus 2 values, minus 3 values total regarding selection made for ‘Date’ dimension. in QlikView