Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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. 

Sue Macaluso
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)