Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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