Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
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.

View solution in original post