Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! 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
sunny_talwar

May be this

Count({<POD_FLAG = {"*"}>}[TRACK NUMBER])

or

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