Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

karan_kn
New Contributor III

Show Null Dimension with Value in Bar chart

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

null.JPG

Dimension: Email_ID

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

10 Replies
passionate
Valued Contributor

Re: Show Null Dimension with Value in Bar chart

Uncheck suppress null from dimension properties

karan_kn
New Contributor III

Re: Show Null Dimension with Value in Bar chart

In Qlik Sense?

passionate
Valued Contributor

Re: Show Null Dimension with Value in Bar chart

Try unchecking this option

ychaitanya
Contributor III

Re: Show Null Dimension with Value in Bar chart

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
Contributor

Re: Show Null Dimension with Value in Bar chart

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
Contributor

Re: Show Null Dimension with Value in Bar chart

Try this

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

Tick Include null values in chart.


Thanks

bvssudhakar
Contributor

Re: Show Null Dimension with Value in Bar chart

Hi

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

priyalvp24
Contributor

Re: Show Null Dimension with Value in Bar chart

Go to  Presentation.

Custom Grid Line Spacing

Select No Lines

bvssudhakar
Contributor

Re: Show Null Dimension with Value in Bar chart

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

Community Browser