topic Re: Month- 1 expression in QlikView

Month- 1 expression

Thu, 24 Mar 2016 07:47:58 GMT

Hello All,

I am trying to calculate the month of my selection minus 1 month and I am using the expression below:

=Count({<Mois_enquete_calcul={"$(=Date(Max(Mois_enquete_calcul), 'MMM-YYYY')-1)"},Q11={'OUI'}>}Q11)

I think I am missing something as it is giving me 0 which is the wrong figure.

Any idea?

Many Thanks,

Hasvine

Kushal_Chawda — Thu, 24 Mar 2016 07:51:50 GMT

try this

=Count({<Mois_enquete_calcul={"$(=Date(Max(Mois_enquete_calcul)-1, 'MMM-YYYY'))"},Q11={'OUI'}>}Q11)

tresB — Thu, 24 Mar 2016 07:54:50 GMT

If you are looking for previous month, try like:

=Count({<Mois_enquete_calcul={"$(=Date(Addmonths(Max(Mois_enquete_calcul),-1), 'MMM-YYYY'))"},Q11={'OUI'}>}Q11)

Thu, 24 Mar 2016 07:55:14 GMT

Thanks Kush.

It works.

Kind Regards,

Hasvine