Listbox

[gautik92]

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]

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 · Accepted solution]

Hi

Try like this

UI:

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

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

Or

Bring in script itself

If(mappingid = 0, products) as Product1

If(mappingid = 1, products) as Product2

[tyagishaila]

Hi,

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

[gautik92]

I want two seperate listboxes not lik this

The formula whic yu have given shows lik this

[PrashantSangle]

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