Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple selection in single list box using tigress

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

2,

3,

5

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.

1 Solution

Accepted Solutions
sateeshkumar
Creator
Creator

Hi,

put this code in onOpen document trigger

select in field:  productId

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

this will work

Regards

Sateesh A

View solution in original post

4 Replies
senpradip007
Specialist III
Specialist III

PFA. Hope it will help.

sateeshkumar
Creator
Creator

Hi,

put this code in onOpen document trigger

select in field:  productId

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

this will work

Regards

Sateesh A

rahulpawarb
Specialist III
Specialist III

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

Anonymous
Not applicable
Author

Hi,

I have attached qvw.

Trigger-

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

Some changes in script, PFA.

Thanks

Paridhi