how can i use count if

[y_vandijk]

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?

[sergio0592]

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]

thanks you very much !!!

it is working

[y_vandijk]

thanks you very much !!!

it is working