topic Re: if condition with count. in QlikView

if condition with count.

Fri, 27 Jan 2017 20:58:02 GMT

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 -

(CUSTOMTYPE_CODE='quoted_ac'

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

swuehl — Fri, 27 Jan 2017 21:20:46 GMT

Try

COUNT(distinct

if(CUSTOMTYPE_CODE='quoted_ac'

and JOB_SUBTYPE_CODE = 'Submission',

JOB_JOBNUMBER))

swuehl — Fri, 27 Jan 2017 21:22:27 GMT