Count without a null value

JAINRAHUL12 — Sat, 16 Nov 2024 18:33:58 GMT

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

Re: Count without a null value

Taoufiq_Zarra — Mon, 01 Jun 2020 10:32:52 GMT

@JAINRAHUL12 can you share a sample data

topic Count without a null value in QlikView

Count without a null value

Re: Count without a null value