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