Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help needed for the file attched.Please.

Please help me with the attched file.

Thanks a lot.

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Use "<Expression>" as the listbox field and define it as

=if([left([Product Long Description],3='AMC', [Product Long Description])

-Rob

tresesco
MVP
MVP

If i have understood right, may be you can try something:

=If([Level Desc 4]='Atlanta - Georgia', WildMatch([Product Long Description], 'AMC*'), [Product Long Description])

Note: be careful of 'Atlanta - Geogia' string, i am not sure if i wrote right.

Edit: Corrected the brace was missing