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: 
y_vandijk
Contributor
Contributor

how can i use count if

hello

i'm a new user of qlik.

i want to  count  how mach track_no have status "sent"

countcount(distinct TRACK_NO) if (STATUS_EXCP_CODE = 'sent)


what is the correct syntax?

4 Replies
sergio0592
Specialist III
Specialist III

Hi,

Use a set analysis with:

count({$<STATUS_EXCP_CODE = {"sent"} >}    distinct TRACK_NO) 

sunny_talwar

As sergio0592‌ set analysis is the way to go for these kind of questions, but in case you want to learn the if syntax... it would look like this

Count(DISTINCT If(STATUS_EXCP_CODE = 'sent', TRACK_NO))

y_vandijk
Contributor
Contributor
Author

thanks you very much !!!

it is working

y_vandijk
Contributor
Contributor
Author

thanks you very much !!!

it is working