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: 
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") 😉