Problem with Timeperiods -> QV Display less values

btrompetter — Mon, 01 Feb 2010 15:47:15 GMT

Hello,

I must make a chart which shows the current sales, the diffenrence to the prev year and to the prev prev year.
I use a free time table to select a time period, because I must compare the monday with the monday.

The sales diagram shows the correct values, but the the diagram for the difference shows one day less.

My filter for the set analyis are:

vFilterDayCY = >=02.01.2010 <=06.01.2010

vFilterDayPY = >=03.01.2009 <=07.01.2009

vFilterDayPPY = >=04.01.2008 <=08.01.2008

The expression for the sales calculation is:

avg( {$<

DATUM = { "$(=vFilterDayCY)" },

$(vLFLFlag) = { "$(=vTotalLFLFilter)" }

>} Umsatz)

and the expression for the difference is

(

avg( {$< DATUM = { "$(=vFilterDayCY)" }, $(vLFLFlag) = { "$(=vTotalLFLFilter)" } >} Umsatz) -

avg( {$< DATUM = { "$(=vFilterDayPY)" }, $(vLFLFlag) = { "$(=vTotalLFLFilter)" } >} Umsatz)

)

avg( {$< DATUM = { "$(=vFilterDayCY)" }, $(vLFLFlag) = { "$(=vTotalLFLFilter)" } >} Umsatz)

And the diagram looks like this:

Did somebody has a hint for me? I didn't know why QV shows less values.

Thanks for help

regards

Bastian

topic Problem with Timeperiods -> QV Display less values in QlikView

Problem with Timeperiods -> QV Display less values