topic compare only completed months in QlikView

compare only completed months

anitamanders — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I want to make a compare between last three completed months and three months before of sales.

So eg. today I want to see sales of march-april-may 2018 compared to December 2017 -jan-feb 2018

therefore I have following functions:

=sum(if (InMonths (3, factdatum, Today(), 0), aantgefact)) but this gives data about april -may-june

=sum(if (InMonths (3, factdatum, Today(), -1), aantgefact)) this gives data about jan-feb-march

I want to exclude the current month (because data is not complete yet)

Can anyone help me out ?

Anil_Babu_Samineni — Tue, 19 Jun 2018 14:27:48 GMT

How about this?

Sum({<factdatum={">=$(=AddMonths(Max(factdatum),-3))<=$(=Max(factdatum))"}>} aantgefact)

And

Sum({<factdatum={">=$(=AddMonths(Max(factdatum),-6))<=$(=AddMonths(Max(factdatum),-3))"}>} aantgefact)

anitamanders — Wed, 20 Jun 2018 08:06:59 GMT

hello, no this doesn't give me the correct data.

Also data changes when I select a productcode (one of the dimensions) so that is strange. Data should be the same.

What I need is now in june:

data from march april may

compared to data from December January February

And on first of july this should automaticly change to data april may june compared to januari February march

etc etc.

Anil_Babu_Samineni — Thu, 21 Jun 2018 13:08:43 GMT

I am not sure - I understand your request..