topic Re: IN operator in qlikview in QlikView

IN operator in qlikview

Anonymous — Mon, 16 Jun 2014 09:40:58 GMT

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

Re: IN operator in qlikview

its_anandrjs — Mon, 16 Jun 2014 09:44:40 GMT

Try with

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

Here i assume Vstatic_emp is a variable.

Re: IN operator in qlikview

tresB — Mon, 16 Jun 2014 09:46:21 GMT

What is the definition of your variable? does it return values separated by comma?

Re: IN operator in qlikview

Anonymous — Mon, 16 Jun 2014 09:47:28 GMT

nope it's not working...Vstatic_emp is a name of variable if i keep it n Quotes i think it will act as a string.

Re: IN operator in qlikview

its_anandrjs — Mon, 16 Jun 2014 09:50:32 GMT

What type of values In Vstatic_emp variable.

Re: IN operator in qlikview

Anonymous — Mon, 16 Jun 2014 09:56:27 GMT

Vstatic_emp is -->GetCurrentSelections([SELF SCORE_Desc])

where SELF SCORE_Desc contains

Load * Inline

[

compe_self_score, SELF SCORE_Desc

0,W

1,DN

2, RS

3, P

4, E

];

Re: IN operator in qlikview

tresB — Mon, 16 Jun 2014 10:02:01 GMT

Redefine your variable like:

=chr(39)& GetFieldSelections([SELF SCORE_Desc] ,chr(39)&','&chr(39) ) &chr(39)

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

Update: Corrected

Re: Re: IN operator in qlikview

Anonymous — Mon, 16 Jun 2014 10:34:22 GMT

Not working.

Please find attached qvw file for reference.

Re: IN operator in qlikview

ashfaq_haseeb — Mon, 16 Jun 2014 10:36:54 GMT

Hi your variable Vstatic_emp is null.

That's why it returned zero.

Select some values in SCORE_Desc you will get it working.

Regards

ASHFAQ

Re: IN operator in qlikview

tresB — Mon, 16 Jun 2014 10:40:18 GMT

You have to realize that, this expression would return a value only when you select some values from your [SELF SCORE Desc] field. And if you don't want it to be so, your simple Count(..) without set analysis should be good enough.

Re: IN operator in qlikview

PradeepReddy — Mon, 16 Jun 2014 10:44:53 GMT

Try the expression:

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

Regards,

Pradeep

Re: IN operator in qlikview

SunilChauhan — Mon, 16 Jun 2014 10:53:26 GMT

use this in variable expression

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

and select values

hope this helps