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