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

Straight Table with only rows where a value in a column equals a text string

How do I use a calculated dimension to only return rows where the value in a specific columns = a specific value in a straight table?

1 Reply
Roop
Specialist
Specialist

Use sum({$<ColumnName={RequiredTextString}>} Sales) as your rule in the expression and ensure that Suppress Zero Values is checked on presentation (which is default) - The examples are all in Set Analysis on the help page.