Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set blanks field to numeric null i.e 0

Hello community,

Today i have a graph problem,

here is some screenshoot, I want to set the values of the x axis, i dont want it to  change. i want to set Missing field value = numeric 0

It X axis année (year in english), i always want to see all values like on image 1, but sometime when i make a selection all value dont appear (Image 2)

For example in this case i want to have a curve pass trough zero at année = 2012, 2013, and 2014.


Capture.PNG

1 Solution

Accepted Solutions
PrashantSangle

Hi,

In expression try below

if(isnull(expression),0,expression)

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 🙂

View solution in original post

7 Replies
PrashantSangle

Hi,

try

1)uncheck Show all Value from dimension tab.

2)Presentation tab uncheck ->Supress Null and Populate Missing Cell

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 🙂
Not applicable
Author

Thanks Max Here is my dimensions Tab, i dont see "Show all value" section

Capture.PNG

Thanks

PrashantSangle

Hi,

Afficher toutes les valeurs means show all values

is your dimension is calculated dimension??

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 🙂
Not applicable
Author

no its not a calculated dimensio, it a field that i load

Not applicable
Author

I dont have a choice to uncheck this case, it Bizarre

Another idea?

Thanks

PrashantSangle

Hi,

In expression try below

if(isnull(expression),0,expression)

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 🙂
jsingh71
Partner - Specialist
Partner - Specialist

hi teneman,

If you dont want your chart get updated based on the selection then select the Read Only property from the chart properties as following:

ReadOnly.png