Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Filter Dimension wrt Measure

Hi,

I have a bar chart where one dimension and two measures available. For some values or selection one of the measure value going 0 or zero but I don't want to show those set of bars where one of the two measure value is 0.

i want to remove those values on axis which contains 0 value by default or after selection.

I am attaching two snapshots which cal clarify both cases stated above.

Tags (1)
3 Replies
MVP
MVP

Re: Filter Dimension wrt Measure

May be something like this:

Change Expression1 to this -> If(RangeMin(Expression1, Expression2) > 0, Expression1)

Change Expression2 to this -> If(RangeMin(Expression1, Expression2) > 0, Expression2)

Not applicable

Re: Filter Dimension wrt Measure

Hi Sunny,

Thanks for your comment, yes its working almost fine , Just one concern left that , measure are perfectly filtering but the dimension values who has null measure also coming on the axis . Can you please help me in this

MVP
MVP

Re: Filter Dimension wrt Measure

Have you checked 'Suppress When Value is Null' on the dimension tab? If not do that and null dimensions should be removed.