Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
YarinInbar
Contributor II
Contributor II

Hide rows based on specific values

I have a sheet with a pivot table that shows inventory of items in our stores.

Item name STORE A (WAREHOUSE) STORE B STORE C STORE D
Item 1 - 0 1 5
item 2 25 1 5 9
item 3 40 1 0 0
item 4 - 0 0 0

 

Dimensions: item description
Column: Store name
Measures: Inventory quantity 

I defined a set expression that filter only items from specific brand, and only specific stores that I want to show.

The only thing remains is that I want to hide items that have no inventory quantity in store A which is our warehouse. 

how can I do that?

 

Labels (1)
  • SaaS

1 Reply
Or
MVP
MVP

By using a different measure, e.g.

[Inventory Quantity] * If({< [Store Name] = {'STORE A'}>} [Inventory Quantity]>0,1)

And then hiding 0/null rows.

If Store A is guaranteed to always be the first store, you could pull this value using the First() function instead.

You could use a similar method with a calculated dimension if you prefer, I believe, but I think in that scenario it'd be less efficient.