if condition with count.

[#1]

Hi all I have this logic of a KPI I want to make a measure in Qlik sense. Can some please help.

COUNT( DISTINCT

CASE

WHEN

CUSTOM_CODE = 'quoted_ac'

AND

SUBTYPE_CODE = 'Submission'

THEN

JOB_JOBNUMBER END

)

I have tried to write the script like this but it didn't work and give me -

if

(CUSTOMTYPE_CODE='quoted_ac'

and  JOB_SUBTYPE_CODE = 'Submission',COUNT(distinct JOB_JOBNUMBER))

[swuehl]

Try

COUNT(distinct

if(CUSTOMTYPE_CODE='quoted_ac'

and  JOB_SUBTYPE_CODE = 'Submission',

JOB_JOBNUMBER))

[swuehl]

See also

It’s all Aggregations

Conditional Aggregations

Use Aggregation Functions!