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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
JAINRAHUL12
Contributor
Contributor

Count without a null value

Hello, I created a Chart using a Dimension which has a certain column which are blanks. I want to calculate my Chart value based on non null values. Initially my input was in Excel than I moved to an Qlik view file version available in Alteryx. Until I was using Excel I could select Suppress null value in Dimension and I did not see null values included in my chart though since I started via QVB file for data import I see a bar in My chart with Column name which is basically all the blank values. 

Please help fix the issue

My expression is simple count(Field Name) 

Regards,

Rahul Jain 

Labels (1)
1 Reply
Taoufiq_Zarra

@JAINRAHUL12  can you share a sample data

Regards,
Taoufiq ZARRA

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

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