Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I summary expressions in a listbox

hello together,

i have a table with a lot of companies:

Companies
Company A
Company B
Company C
Company D
Company E

I would like to have a Listbox with two expressions :

Listbox
Company A
Non Company A

Do you know, how can I implementate this logic?

Thank you.

Greetings

Jörn

1 Solution

Accepted Solutions
kouroshkarimi
Creator III
Creator III

In your script you could add a simple column to the table along the lines of:

if(Companies='Company A', 'Company A', 'Non Company A') as Filter

And then create a Listbox based on this new Filter field.

View solution in original post

2 Replies
kouroshkarimi
Creator III
Creator III

In your script you could add a simple column to the table along the lines of:

if(Companies='Company A', 'Company A', 'Non Company A') as Filter

And then create a Listbox based on this new Filter field.

Not applicable
Author

Make an variable of companies, otherwise you need to hardcode every company.

So vCompanies = Companies

=if(Companies=vCompanies,vCompanies,'NON '&vCompanies)

Is that how you want it?