Skip to main content
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") 😉