KPI Count of Rows

[BrianDH]

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

[Qlik1_User1]

your expression is correct - Count({<STATUS={'Approved'}>} distinct REPORTID)

Check at data model level if something is missing.