Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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