topic Re: Error in expression in QlikView

Error in expression

Tue, 22 Mar 2016 09:50:58 GMT

Hello All,

Could you please help me with this expression:

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

Qlikview says that the Expression OK but unfortunately I do not get any result.

Many Thanks,

Hasvine

Re: Error in expression

Chanty4u — Tue, 22 Mar 2016 09:54:31 GMT

=Count({<Mois_enquete_calcul={">=$(=Max(Mois_enquete_calcul) - 5)<=$(=Max(Mois_enquete_calcul))"},Q11={'OUI'}, MARQUE={'CITROEN'}>}Q11)

Re: Error in expression

Gysbert_Wassenaar — Tue, 22 Mar 2016 09:54:33 GMT

The syntax of the expressions is fine. Please post a small qlikview document that demonstrates the issue.

Re: Error in expression

Kushal_Chawda — Tue, 22 Mar 2016 09:58:51 GMT

if Mois_enquete_calcul is in proper date format then below expression should work

Count({<Mois_enquete_calcul={">=$(=Max(Mois_enquete_calcul) - 5)<=$(=Max(Mois_enquete_calcul))"},Q11={'OUI'}, MARQUE={'CITROEN'}>}Q11)

Re: Error in expression

Tue, 22 Mar 2016 10:02:24 GMT

But if Mois_enquete_calcul is in the format of Month-Year.

I used the expression below to calculte it:

Month(subfield([DATE_FACTURATION], ' ' ,1)) & '-' & Year(subfield([DATE_FACTURATION], ' ' ,1)) as Mois_enquete_calcul,

This is how it looks like:

Many thanks to everyone for your help.

Kind Regards,

Hasvine

Re: Error in expression

stabben23 — Tue, 22 Mar 2016 10:04:55 GMT

if you put this Expression in a straight table, what does is stand in the "label header" if you keep it blank and hover over it?

Re: Error in expression

Gysbert_Wassenaar — Tue, 22 Mar 2016 10:05:12 GMT

Ok, so it's a text field. The max function doesn't work well with text fields. Try creating it like this:

Date(MonthStart(subfield(DATE_FACTURATION,' ')),'MMM-YYYY') as Mois_enquite_calcul.

Re: Error in expression

Kushal_Chawda — Tue, 22 Mar 2016 10:05:53 GMT

It's in not proper date format, do this like below

date(date#(Month(subfield([DATE_FACTURATION], ' ' ,1)) & '-' & Year(subfield([DATE_FACTURATION], ' ' ,1)),'MMM-YYYY'),'MMM-YYYY') as Mois_enquete_calcul

Now your expression should work

Re: Error in expression

Tue, 22 Mar 2016 10:21:06 GMT

Hello All,

Thanks you for your ideas, the good news is that now my chart shows the result but it doesn't give me only 6 months but more.

Following my selection on déc-2015 i want Qlikview to show me the month of nov-2015, oct-2015, sept-2015, aug-2015 and jul-2015

but instead, it is giving me all the months before dec-2015

Any idea how to solve this?

Many Thanks,

Hasvine

Re: Error in expression

stabben23 — Tue, 22 Mar 2016 19:12:04 GMT

Try this,

Count({<Mois_enquete_calcul={">=$(=(Addmonth(Mois_enquete_calcul, - 5)))<=$(=(Addmonth(Mois_enquete_calcul,0)))"},..........