Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filtering with a groups dimension

Hi,

I haven't been able to find any answers to this question, so I'm hoping I'm not repeating an existing discussion, but here goes!

I have a chart that displays a grouped dimension (city, state, country) and a metric.  There is an unknown value in each one of these dimensions, but that unknown value is different for each one - Unknown City and Unknown State.  I'd like to filter out the unknowns when the group dimension is cycled to city or state because it's the dimension with the largest number of rows, and skews the look of the graph.  However, I don't want that filtering to affect the other dimensions.

Essentially, what I'm looking for is conditional filtering of the dimension, based on the group dimension I'm currently showing.  Any advice?  Thanks!

George

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

You may define unknown values as nulls. Then if you plot the chart with 'Suppress When Value is Null' in the Dimensions tab of chart properties checked, you will get the desired result. The attached example illustrates this.

View solution in original post

1 Reply
nagaiank
Specialist III
Specialist III

You may define unknown values as nulls. Then if you plot the chart with 'Suppress When Value is Null' in the Dimensions tab of chart properties checked, you will get the desired result. The attached example illustrates this.