Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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])