Show Null Dimension with Value in Bar chart

[karan_kn]

Show 'Null' Dimension with Value in Bar chart Qlik Sense

Dimension: Email_ID

Expression: Count({<object_type={'standard'},status={'New'}>} folder)

[passionate]

Uncheck suppress null from dimension properties

[karan_kn]

In Qlik Sense?

[passionate]

Try unchecking this option

[ychaitanya]

if you use the default option to get null you will end up having " -"

try something like this in dim expr

if(isnull(Dimension),'Null',Dimension)

Thanks

CY

[jasonmomoa]

Hello karan_kn‌,

You'll need to do 2 steps to show it like you want to:

1. In the visualization's property panel, you should check the 'Include null values' option in the x-axis dimension.
2. As it will appear as '-' in the visualization, you should replace this value in the script. As an example:
   M_EMAILS:
   LOAD Distinct
     *,
     If(isNull(Email_ID), 'Null', Email_ID) as New_Email_ID

        Resident Table;

Hope this helps.

Regards

[priyalvp24]

Try this

If(IsNull(Email_ID), Null(), Email_ID) as Email_ID.

Tick Include null values in chart.

Thanks

[bvssudhakar]

Hi

Can you guys tell me how remove the backside grid for charts

[priyalvp24]

Go to  Presentation.

Custom Grid Line Spacing

Select No Lines

[bvssudhakar]

I have created combo chart, for that i haven't find Custom grid line spacing option in presentation.

And i am using Qlik Sense Desktop Edition