set analysis - less than

[#1]

Hey everyone,

I cannot make the following expression work..

The error is where I have the {">6"}.

count ({$< Etape_formulaire={'Validation'}, [Dossier Complet]={1}, Num(Month([Mois Année Dossier Complet]))={">6"} >} Compteur) 

What's wrong with my expression ?

Thank you for your help

Have a good day

Laura

[sasiparupudi1]

you can not use an expression on the LHS

Num(Month([Mois Année Dossier Complet]))

[#3]

What is "LHS" ?

[sasiparupudi1]

sorry, its left hand side..

Instead you can create a field in the script

as Num(Month([Mois Année Dossier Complet])) as Mois Année Dossier Complet Month

and in the set analysis

count ({$< Etape_formulaire={'Validation'}, [Dossier Complet]={1}, [Mois Année Dossier Complet Month]))={">6"} >} Compteur) 

hth

Sasi

[krishna_2644]

try this:

count ({$< Etape_formulaire={'Validation'}, [Dossier Complet]={1},

[Mois Année Dossier Complet] = {$(=Num(Month([Mois Année Dossier Complet]))={">6"} >} )}

Compteur)

[ChiragPradhan]

Easier to create another field with Month number as Sasidhar pointed. More effecient and readable.

Regards

Chirag

[ramoncova06]

do you have an ID field or something like a unique identifier ?

if you do then you should be able to use

count ({$< Etape_formulaire={'Validation'}, [Dossier Complet]={1}, ID={"=Num(Month([Mois Année Dossier Complet]))>6"} >} Compteur)

[sasiparupudi1]

Hi

Have you found a solution yet?

Sasi

[qlikviewwizard]

Hi Laura,

Are you able to manage to get the solution?