topic Re: NULL values in QlikView

NULL values

Thu, 03 Apr 2014 12:57:00 GMT

I have expressions which are resulting some data to return a - i.e. a null. In addition i have dimensions in the same chart objects that may have a -. I have used the presentation tab on chart properties to set the null symbol to Unknown on the dimension column for example. However it seems that this applies to all columns in the chart not just the one i which to select against. Is this correct behavior? If so how can i get around both of these issues?

Thanks

Re: NULL values

its_anandrjs — Thu, 03 Apr 2014 13:01:19 GMT

Another way you can use Isnull() function for any specific dimension like

If( Isnull(YourNullfield) = -1,'Unknown',YourNullfield)

Re: NULL values

Thu, 03 Apr 2014 13:04:24 GMT

so lets say I have the following:

DerivedX/RowCounter and I have named my expression as Profit then how would your example apply?

Also how would you example apply to a dimension field. Would this be done in the script or within the chart objects propoerty

Re: NULL values

its_anandrjs — Thu, 03 Apr 2014 13:07:00 GMT

In Expression and in script level both you are able to do with this

If( Isnull(YourNullfield) = -1,'Unknown',YourNullfield)

Re: NULL values

PradeepReddy — Thu, 03 Apr 2014 13:11:53 GMT

Hi,

In Script,

NullAsValue Field1,Field2..;

Set NullValue='@'; // Any symbol

Load the script.

Use the symbol(@) in expression instead of Null value.

Hope this helps you.

Thanks

Pradeep

Re: NULL values

Thu, 03 Apr 2014 13:13:09 GMT

okay thats worked on the dimension in the expression area.

How about in the this example:

Ave Stay I have values which are showing as -. I want these to be replaced with 0. This is a calculated expression DerivedX/Row

Re: NULL values

its_anandrjs — Thu, 03 Apr 2014 13:21:06 GMT

Ok i suggest in the load script you replace or change the symbol '-' to 0 then use it in the Expressions or dimension.

Re: NULL values

PradeepReddy — Thu, 03 Apr 2014 13:21:58 GMT

As I understand the requirement, you need to replace the Null value in Dimension with Zero.

This may helps partially.. it won't show the Nullable dimension.

Select the option "Suppress When Value IS Null" from dimensions tab.

Re: NULL values

Thu, 03 Apr 2014 13:22:56 GMT

the only thing is the expression is in the chart object not in the script.

Re: NULL values

PradeepReddy — Thu, 03 Apr 2014 13:26:08 GMT

Select the option "Suppress When Value IS Null" from dimensions tab from object properties...

Chart Properties---> Dimensions --> Choose the dimension -- > "Suppress When Value Is Null" (select this option)

Re: NULL values

its_anandrjs — Thu, 03 Apr 2014 13:39:07 GMT

Then use (Suppress When Value Is Null) option from chart.

Re: NULL values

Thu, 03 Apr 2014 13:42:44 GMT

there is no supress when value is null. there is only the opition if missing

Re: NULL values

PradeepReddy — Thu, 03 Apr 2014 13:52:30 GMT

In which tab you are looking?

Check in the Dimensions tab of Chart properties window..