Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

khanashique
Contributor

Count Expression

Hi Experts,

Below count expressions which works fine:

COUNT({$<QC-={'NA'}>}DEPARTMENT)

COUNT({$<QC-={"=QC like 'NA'"}>}DEPARTMENT)

it does not work, when i add another condition to existing expression:

COUNT({$<PROD-={"=PROD like 'NA'"},QC-={"=QC like 'NA'"}>}DEPARTMENT)

COUNT({$<QC-={'NA'},PROD-={'NA'}>}DEPARTMENT)

Thanks,

MAK.

Tags (1)
1 Solution

Accepted Solutions
thiago_justen
Valued Contributor III

Re: Count Expression

Try this out:

COUNT({$<QC-={'NA'}>+<PROD-={'NA'}>}DEPARTMENT)

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
7 Replies
b_knuever
Contributor III

Re: Count Expression

try QC={"*NA*"} also for the others

khanashique
Contributor

Re: Count Expression

Hi Thanks for your quick reply,

I have tried that wild card " * " but hard luck it works only for single expression...

Thanks,

MAK

sasiparupudi1
Honored Contributor III

Re: Count Expression

Do you get correct value when you use

COUNT({$<PROD-={"=PROD like 'NA'"}>}DEPARTMENT)?

thiago_justen
Valued Contributor III

Re: Count Expression

Try this out:

COUNT({$<QC-={'NA'}>+<PROD-={'NA'}>}DEPARTMENT)

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
khanashique
Contributor

Re: Count Expression

Yes

khanashique
Contributor

Re: Count Expression

Hi Thiago,

Thanks this works...even below can also help:

(COUNT({$<PROD-={'NA'}>}DEPARTMENT) + COUNT({$<QC-={'NA'}>}DEPARTMENT))

Thanks,

MAK.

thiago_justen
Valued Contributor III

Re: Count Expression

Sound's good man. I'm happy to help you.

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
Community Browser