Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
btrompetter
Contributor III
Contributor III

Problem with Timeperiods -> QV Display less values

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:

error loading image


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

Thanks for help

regards

Bastian

0 Replies