topic Re: Listbox in QlikView

Listbox

gautik92 — Wed, 15 Jul 2015 05:55:46 GMT

I have a listbox with list of products which have mappingid 0 and 1

I want to show those products which belong to 0 and 1 seperately in the listbox .

Thanks in advance

vardhancse — Wed, 15 Jul 2015 06:04:28 GMT

So you want 2 separate list box one having mappingid=0 and naother mapingid=1

the create one list box->Properties->expression->if(mappingid=0,product)

Another list box->Properties->expression->if(mappingid=1,product)

MayilVahanan — Wed, 15 Jul 2015 06:06:21 GMT

Try like this

UI:

Listbox1 - Expression: =Aggr(only({1<maapingid= {1}>}products ),products )

Listbox2 - Expression: =Aggr(only({1<maapingid= {0}>}products ),products )

Bring in script itself

If(mappingid = 0, products) as Product1

If(mappingid = 1, products) as Product2

tyagishaila — Wed, 15 Jul 2015 06:07:42 GMT

Hi,

for this you can use expression in ListBox rather than field name.

gautik92 — Wed, 15 Jul 2015 06:09:09 GMT

I want two seperate listboxes not lik this

The formula whic yu have given shows lik this

PrashantSangle — Wed, 15 Jul 2015 06:14:57 GMT

Hi,

If mapping id field and Product from same table then

create new field in script

try like,

if(MappingId='1',Product) as Product1

and

if(MappingId='2',Product) as Product2

Regards