Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

IN operator in qlikview

Hi All,

I am facing an issue to store multiple values returned by the variable.

In chart Expression i have to store the values returned by variable but unable to do it is count expression like :

=count({<[SELF SCORE_Desc]   {(Vstatic_emp)}>} compe_self_score)

In above expression variable(Vstatic_emp has 5 values which he returned these has to compare with SELF SCORE_Desc) equal to is not useful.

Kindly Suggest.

Thanks

Manish

11 Replies
PradeepReddy
Specialist II
Specialist II

Try the expression:

=count({<[SELF SCORE_Desc]   { $(Vstatic_emp) }>} compe_self_score)

Regards,

Pradeep

SunilChauhan
Champion II
Champion II

use this in variable expression

Vstatic_emp=concat(getfieldselections(SELF SCORE_Decs),',')

and select values

hope this helps


Sunil Chauhan