topic Re: Multiple selection in single list box using tigress in QlikView

Multiple selection in single list box using tigress

Fri, 05 May 2017 06:54:13 GMT

Hi All,

i am looking for below requirement solutions can anyone help me with solutions.

I have Inline table like Product

ProductID, ProductName

1, Computers

2, Mobiles

3, Laptops

4, Large Acc

5, ACs

and i have another table comes from Excel:

Products Table:

Product_ID

When ever excel can reload defaulting excel sheet-> Product id's has to select in my listbox...

Can anyone help me asap.

Please note using macro i need it.

Thanks,

Surya.

Kushal_Chawda — Fri, 05 May 2017 07:04:47 GMT

try to apply trigger onOpen, or on Active sheet which you have applied on button

Fri, 05 May 2017 07:08:36 GMT

This need to do in Macro

ankit777 — Fri, 05 May 2017 07:22:33 GMT

Create a variable like

var=concat(excel_productid,'|')

then create an action on post reload

select in field - Product_ProductID

value- ='('&var&')'

This will select all product value in excel in the products table every time you reload.