Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
y_vandijk
Contributor
Contributor

count TRACK NUMBER if POD_FLAG is not null - IN QLIK SENSE

hello,

i have a table:

TRACK NUMBERPOD_FLAG
1234-
56781
90120
34561
7890-
23451

i want to count just the track numbers that have value in POD_FLAG

in this example the answer should be 4

what the condition i shuld write?

1 Reply
tresesco
MVP
MVP

Something like:

Count( {<[TRACK NUMBER]={"=Len(Trim([TRACK NUMBER]))>0"}>}[TRACK NUMBER])