topic Re: set analysis - less than in QlikView

set analysis - less than

Wed, 26 Aug 2015 14:16:10 GMT

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

Re: set analysis - less than

sasiparupudi1 — Wed, 26 Aug 2015 14:19:09 GMT

you can not use an expression on the LHS

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

Re: set analysis - less than

Wed, 26 Aug 2015 14:25:20 GMT

What is "LHS" ?

Re: set analysis - less than

sasiparupudi1 — Wed, 26 Aug 2015 14:28:07 GMT

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

Re: set analysis - less than

Qrishna — Wed, 26 Aug 2015 14:28:51 GMT

try this:

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

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

Compteur)

Re: set analysis - less than

ChiragPradhan — Wed, 26 Aug 2015 14:54:45 GMT

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

Regards

Chirag

Re: set analysis - less than

ramoncova06 — Wed, 26 Aug 2015 15:01:21 GMT

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)

Re: set analysis - less than

sasiparupudi1 — Tue, 01 Sep 2015 12:48:31 GMT

Have you found a solution yet?

Sasi

Re: set analysis - less than

qlikviewwizard — Wed, 02 Sep 2015 01:55:10 GMT

Hi Laura,

Are you able to manage to get the solution?