Dynamic filter

Tue, 22 Mar 2016 12:25:10 GMT

Hello All,

Attached you will find a sample.

I have 'DATE FACTURATION' in my data source which i converted into 'Mois_enquete_calcul' to get the Month&Year.

AND my expression is:

=Count({<Mois_enquete_calcul={'>=$(=Max(Mois_enquete_calcul)-3)<=$(=Max(Mois_enquete_calcul))'},Q11={'OUI'}, MAKE={'CITROEN'}>}Q11)

Actually what I need is that when I choose on nov.-2015 in my 'Mois_enquete_calcul' selector I get only the month of nov.-2015, oct.-2015, sept.-2015 and aug.-2015.

Right now, when I choose a given month it shows all the months before the month I chose.(like it does not stop at the month -3)

Any one has an idea how I can perform that please.

I tried many ways but I am stuck.

Thanks,

Hasvine

Re: Dynamic filter

sunny_talwar — Tue, 22 Mar 2016 12:30:24 GMT

Try this:

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

Re: Dynamic filter

Wed, 23 Mar 2016 08:22:54 GMT

Thanks Sunny.

It works.

KR,

Hasvine

topic Dynamic filter in QlikView

Dynamic filter

Re: Dynamic filter

Re: Dynamic filter