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:03:33 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.

Re: Multiple selection in single list box using tigress

senpradip007 — Fri, 05 May 2017 06:13:29 GMT

PFA. Hope it will help.

Re: Multiple selection in single list box using tigress

sateeshkumar — Fri, 05 May 2017 06:19:26 GMT

Hi,

put this code in onOpen document trigger

select in field: productId

search string: ='(' & Concat(Product_ID,'|') &')'

this will work

Regards

Sateesh A

Re: Multiple selection in single list box using tigress

rahulpawarb — Fri, 05 May 2017 06:22:05 GMT

Hello Surya,

As a workaround, please follow below steps:

1. Open Document Properties and locate Triggers tab.

2. Select OnPostReload from Document Event Triggers and press Add Action(s)... button.

3. Press Add button and select Selection as Action Type , Select In Field as Action

4. Enter below values:

Field: ProductID

Search String: = '(' & Concat(Product_ID, '|') & ')'

Hope this will be helpful.

Regards!

Rahul

Re: Multiple selection in single list box using tigress

Anonymous — Fri, 05 May 2017 06:24:50 GMT

Hi,

I have attached qvw.

Trigger-

='('&Concat(flag,'|')&')'

Some changes in script, PFA.

Thanks

Paridhi