set analysis help

[Marissa23]

Hello,

I have created an expression that returns correct results, but I'm having a hard time with set analysis.

I would like to add logic so that the expression ignores a specific filter called quality_sid. I have added the following set analysis but it returns 0 and that is wrong.

Could anyone help me out?

1-num(Count(${<quality_sid=, <metric={'Material Reversals'}>} distinct unique_finding_id)/Count(${<quality_sid=,<metric={'Denominator'}>} distinct unique_finding_id),'#,#%')

Thank you!

Marissa

[rwunderlich]

Too many angle <  brackets. And the num should be on the outside. Should be:

num(
  1 - (
    Count(${<quality_sid=, metric={'Material Reversals'}>} distinct unique_finding_id)
    /Count(${<quality_sid=,metric={'Denominator'}>} distinct unique_finding_id)
  )
,'#,#%')

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