topic Re: set blanks field to numeric null i.e 0 in QlikView

set blanks field to numeric null i.e 0

Thu, 25 Jun 2015 07:34:54 GMT

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.

Re: set blanks field to numeric null i.e 0

PrashantSangle — Thu, 25 Jun 2015 07:44:39 GMT

Hi,

try

1)uncheck Show all Value from dimension tab.

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

Regards

Re: set blanks field to numeric null i.e 0

Thu, 25 Jun 2015 07:52:19 GMT

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

Thanks

Re: set blanks field to numeric null i.e 0

PrashantSangle — Thu, 25 Jun 2015 08:00:23 GMT

Hi,

Afficher toutes les valeurs means show all values

is your dimension is calculated dimension??

Regards

Re: set blanks field to numeric null i.e 0

Thu, 25 Jun 2015 08:02:21 GMT

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

Re: set blanks field to numeric null i.e 0

Thu, 25 Jun 2015 08:03:44 GMT

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

Another idea?

Thanks

Re: set blanks field to numeric null i.e 0

PrashantSangle — Thu, 25 Jun 2015 08:10:12 GMT

Hi,

In expression try below

if(isnull(expression),0,expression)

Regards

Re: set blanks field to numeric null i.e 0

jsingh71 — Thu, 25 Jun 2015 08:16:16 GMT

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: