Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Valued Contributor III

Re: Filtering with a groups dimension

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.

1 Reply
nagaiank
Valued Contributor III

Re: Filtering with a groups dimension

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.

Community Browser