
Not applicable
2017-01-27
03:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if condition with count.
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))
9,050 Views
2 Replies


MVP
2017-01-27
04:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
COUNT(distinct
if(CUSTOMTYPE_CODE='quoted_ac'
and JOB_SUBTYPE_CODE = 'Submission',
JOB_JOBNUMBER))
8,340 Views


MVP
2017-01-27
04:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
8,340 Views
