topic List Box Expression in QlikView

List Box Expression

bharatkishore — Wed, 27 May 2015 05:50:22 GMT

Dear All,

I have a field called Name: And in that name i have like 10 subfields and i need to display only 3 subfields in a list box..I have given the following expression..

=if(name ='A1' or name ='A2' or name ='A3',name)

In chart dimension it is working fine but when i take in list box it is not working..Can you please help me how to do it.. i need to filter in only list box..

Regards,

Bharat

Re: List Box Expression

danieloberbilli — Wed, 27 May 2015 05:54:13 GMT

try

=if(match(name,'A1','A2','A3'),name)

Re: List Box Expression

amit_saini — Wed, 27 May 2015 06:05:27 GMT

Bharat,

Two ways:

Script side:

Where match(name,'A1','A2','A3') ;

Front End:

=if(match(name,'A1','A2','A3'),name)

Thanks,

Re: List Box Expression

sagarkharpude — Wed, 27 May 2015 06:10:25 GMT

Better to do in a script as below:

if(match(name,'A1','A2','A3'),name) as Name_New

And use this Name_New field in frontend

Re: List Box Expression

prajapatiamar38 — Wed, 27 May 2015 06:10:27 GMT

Hi.....

Please find the attached Qvw.

Please Refer the example.

Re: List Box Expression

jonathandienst — Wed, 27 May 2015 06:13:28 GMT

=Aggr(Only({<name = {'A1', 'A2', 'A3'}>} name), name)

Re: List Box Expression

bharatkishore — Wed, 27 May 2015 06:31:38 GMT

Thanks Amarnath