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

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
neha3003
Contributor
Contributor

dimension Filter

I want to create a table box with multiple dimension which should show the data only for the status = #NA and status = Unknown

Labels (1)
3 Replies
Sue_Macaluso
Community Manager
Community Manager

@neha3003 Are you using QlikView or Sense? I would like to move this into the correct product forum. 

Did you find a solution to your question? Mark the solution as accepted : and if you found it useful, press the like button!
neha3003
Contributor
Contributor
Author

Hi Sue_Macaluso,

I am using Qliksense

miskinmaz
Creator III
Creator III

to all the expression you have used in your table box use the set analysis like

Instead of just sum(Sales) 

try sum({<Status={"NA","Unknown"}>}Sales)