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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
joshrussin
Creator III
Creator III

If statement help

Trying to filter out two fields in an if statement as a dimension on a table.

I just want to filter out 'Distribution Orders' and 'Decon - Totes' from the 'Program_Dash' field.

select.PNG

Capture4.PNG

2 Replies
sunny_talwar

May be like this in your dimension

If(Match(Program_Dash, 'Distribution Orders', 'Decon - Totes'), Program_Dash)

Or use set analysis in your expression

Sum({<Program_Dash = {'Distribution Orders', 'Decon - Totes'}>}Measure)

shiveshsingh
Master
Master

u can try this as your dimension

If(Match(Program_Dash, 'Distribution Orders', 'Decon - Totes'), Program_Dash)