topic Re: Set Analysis: more values of Field from variable in QlikView

Set Analysis: more values of Field from variable

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have this trouble:

my variable gets the selected values of a field:

set v_tipologia =GetFieldSelections(Tipo.Selezione,',',20);

for example, a possible return is the following string:

Delta,Disp

I need use it in the following graph expression but not work:

Count({$<Tipologia2={'$(v_tipologia)'}>}[Key ATT])

Any aid?

Thanks so much!

Re: Set Analysis: more values of Field from variable

Chanty4u — Fri, 01 Apr 2016 08:11:06 GMT

u miss single quote?

set v_tipologia ='GetFieldSelections(Tipo.Selezione,',',20)';

Re: Set Analysis: more values of Field from variable

Fri, 01 Apr 2016 08:16:53 GMT

I mean the problem is the graph expression no the variable. Yours doesn't work

Re: Set Analysis: more values of Field from variable

kaushiknsolanki — Fri, 01 Apr 2016 08:17:10 GMT

Hi,

Try this.

Count({<Tipo.Selezione = {$(=GetFieldSelections(Tipo.Selezione))}>}DISTINCT [Key ATT])

Regards,

Kaushik Solanki

Re: Set Analysis: more values of Field from variable

tamilarasu — Fri, 01 Apr 2016 08:22:04 GMT

Hi,

Try,

Count({<[Tipo.Selezione]={'$(=concat(distinct [Tipo.Selezione],chr(39)&','&chr(39)))'}>}Open)

Re: Set Analysis: more values of Field from variable

Fri, 01 Apr 2016 08:31:04 GMT

I have tried both suggests but they count all elements [Key ATT], without considerering the set

Re: Set Analysis: more values of Field from variable

Kushal_Chawda — Fri, 01 Apr 2016 08:32:27 GMT

Create Variable on front end like this

v_tipologia =Concat(distinct Chr(39)&Tipo.Selezione&chr(39),',');

Now write the expression

Count({$<Tipologia2={$(v_tipologia)}>}[Key ATT])

Expression will show error but it will work.

Re: Set Analysis: more values of Field from variable

Fri, 01 Apr 2016 08:39:09 GMT

Perfect! Thanks

Re: Set Analysis: more values of Field from variable

perumal_41 — Fri, 01 Apr 2016 08:40:13 GMT

try below one

v_tipologia = =chr(39)& Replace(GetFieldSelections(Tipo.Selezione,',',20),',',chr(39)&','&chr(39))&chr(39)

Count({$<Tipologia2={$(v_tipologia)}>}[Key ATT])

Re: Set Analysis: more values of Field from variable

sunny_talwar — Fri, 01 Apr 2016 08:43:57 GMT

This should also work:

LET v_tipologia = Chr(39) & GetFieldSelections(Tipo.Selezione,Chr(39) & ',' & Chr(39), 20) & Chr(39);

and then your count expression needs to be without single quotes:

Count({$<Tipologia2={$(v_tipologia)}>}[Key ATT])