Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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])