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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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