topic Re: Condition Date in QlikView

Condition Date

MauriceLudo — Mon, 09 Apr 2018 11:40:39 GMT

Hi,

Please I would like to calculate the sum of sales before and after March 2018:

- if date > March 2018 : sum({<[Produits/Services]={'NSS & CCD '}>}[VENTE PRIS])

- if Date < March 2018 : sum({<[Produits/Services]={'NSS'}>}[VENTE PRIS])

please what is the best solution

Thank you

Best regards

Maurice

HarishG — Mon, 09 Apr 2018 11:46:35 GMT

Are you gonna use March 2018 static date?

MauriceLudo — Mon, 09 Apr 2018 11:52:32 GMT

Yes

HarishG — Mon, 09 Apr 2018 12:41:42 GMT

May be this should work from what i understood with your requirement :

if(Max(Date)< 01-March-2018, sum({<[Produits/Services]={'NSS'}>}[VENTE PRIS]),

sum({<[Produits/Services]={'NSS & CCD '}>}[VENTE PRIS])).

if(Max(Date)< '01-March-2018', sum({<[Produits/Services]={'NSS'}>}[VENTE PRIS]),

if(Max(Date)>= '01-March-2018', sum({<[Produits/Services]={'NSS & CCD '}>}[VENTE PRIS])).

you need to change the march 2018 as per your Calendar date format. And instead of Max(Date), you can use Today().