Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having no luck getting my count. In SQL developer my number is 230. In Qlik I get nothing or 13K
I have tried:
if (STATUS = 'Approved' ,Count(distinct REPORTID))
count ( distinct if(STATUS='Approved', REPORTID))
count( distinct {$<STATUS={'Approved'}>} REPORTID)
Count({$<STATUS={'Approved'}>} distinct REPORTID)
Suggestions
your expression is correct - Count({<STATUS={'Approved'}>} distinct REPORTID)
Check at data model level if something is missing.