Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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