Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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.

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.
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.
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.
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