Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
bickyqlik
Contributor II
Contributor II

Getting count of not null/not blank rows of a column

I have a table where I have below two columns

col1      col2

A1            A2

                  A21

A23   

A24          A25

I need to have a count of NOTNULL/NOTBLANK col2 where col1 should not be NULL/BLANK.

Basically I need count of rows where values are present in both the columns

Any help on this. I need it in Analysis-UI 

1 Reply
Taoufiq_Zarra

@bickyqlik  Maye be like:

=count({<col1={"=len(trim(col1))>0"},col2={"=len(trim(col2))>0"}>}col1)

output:

Taoufiq_Zarra_0-1620137853178.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉