Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Null Symbol in Bar chart

Hi ,

i need to represent the null values as unclassified in bar chart and when i am checking the null values in dimension it showing on the desktop but not on the client .

Dimension:

If(Len(Trim([CustRating Quantitative_Summary])) = 0,'Unclassified',[CustRating Quantitative_Summary])

View on Desktop :

Capture _Bar_Desktop.JPG.jpg

View on Access Point:

Capture_bar.JPG.jpg

Thanks & Regards,

Saurabh

27 Replies
sasikanth
Master
Master

Have you tried the logic at script level ?

sundarakumar
Specialist II
Specialist II

I can see u are using a drillown there. have u created it in

doc properties -> groups -> edit (the particular dim)?

better push it to back end...

If u have pushed it to back end as described by sassikanth then u would not see a null there..

-Sundar

PrashantSangle

Hi,

In dimension tab->Un Select Supress when value is Null

and select-> Show All Values.

or

Delete that object and recreate it.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
jyothish8807
Master II
Master II

Hi,

Try writing the expression in script instead of chart and select show all values and un select supress when value is Null.

Regards

KC

Best Regards,
KC
Not applicable
Author

Hi Saurav

It works fine .try to download IE plugin

Not applicable
Author

Hi shweta ,

Not Working .

Regards,

Saurabh

sathishkumar_go
Partner - Specialist
Partner - Specialist

Hi Saurabh,

Can u republish the application and try it!

-Sathish

annafuksa1
Creator III
Creator III

Can you share your app ?

annafuksa1
Creator III
Creator III

Try this settings Untitled.png

Anonymous
Not applicable
Author

Hi Saurabh,

I also had issue but that was like in Pivot and straight table separating line were not appearing that was because of browser issue they were trying to access app in chrome, But on IE it worked.

Try this if it is helpful.

Thanks