Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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])