Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
khanashique
Creator II
Creator II

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.

1 Solution

Accepted Solutions
Thiago_Justen_

Try this out:

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

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

View solution in original post

7 Replies
bramkn
Partner - Specialist
Partner - Specialist

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

khanashique
Creator II
Creator II
Author

Hi Thanks for your quick reply,

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

Thanks,

MAK

sasiparupudi1
Master III
Master III

Do you get correct value when you use

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

Thiago_Justen_

Try this out:

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

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
khanashique
Creator II
Creator II
Author

Yes

khanashique
Creator II
Creator II
Author

Hi Thiago,

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

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

Thanks,

MAK.

Thiago_Justen_

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

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