Filter when Master Measure = 0

[simonB2020]

I have a chart with a Master Measure 

Quite simply I want to only show records where the Master Measure value = 0

Can't see a way of doing this without breaking the link with MM and using Set Analysis.

Any ideas ?

Thanks

[rwunderlich]

If you can address the requirement with a Set, than you can use an outer set along with the Master Measure name like:

{yourset} yourmeasure

Or you can refer to the Measure in an if() statement in a Calculated Dimension. For a measure name of [Sales CYTD] and a Dimension of [Company Name]

=Aggr(if([Sales CYTD] > 0, [Company Name]), [Company Name])

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com