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: 
mapratt82
Creator
Creator

Dimension Filtering

I'm wanting to filter out the accounts that do not have 840 External_Trans_Code, but have more than 3 transactions that are External_Trans_Code 137, 145, and/or 146. Thanks

3 Replies
jduarte12
Partner - Creator II
Partner - Creator II

Use an if expression or set analysis.

miguelbraga
Partner - Specialist III
Partner - Specialist III

Why not using two bookmarks and/or a conditional search?

miguelbraga
Partner - Specialist III
Partner - Specialist III

You can filter this by using a WHERE clause in the script after LOAD if you don't want permanently those values. If you want to filter in a Listbox, please read my sugestion above. If you're want to filter in a expression please follow João Nuno Duarte's sugestion