topic Re: NULL as a data point in qlikview in QlikView

NULL as a data point in qlikview

Mon, 27 Oct 2014 09:19:21 GMT

Here are the first three rows of my data

Team Name	Role Count
A	10
B	10
NULL	11

I want the table box/pie chart to display this data from the table as it is. But the table box/pie chart automatically ignores the value - 'NULL' .So instead of getting the total count as 31 in my chart objects, I just get 20. How can I solve this?

Re: NULL as a data point in qlikview

Gysbert_Wassenaar — Mon, 27 Oct 2014 09:23:40 GMT

Enable the option Show All Values for the Team Name dimension. A better solution is to replace the nulls with real values in the script. See this document for more information: NULL handling in QlikView

Re: NULL as a data point in qlikview

Mon, 27 Oct 2014 09:25:12 GMT

Qlikview interprets NULL in the dataset as '-'. I want it to interpret it as a team named 'NULL'

Re: NULL as a data point in qlikview

ashfaq_haseeb — Mon, 27 Oct 2014 09:28:02 GMT

Hi,

alt function

alt(null(), 0)

alt(yourfield, 0)

alt(case1[ , case2 , case3 , ...] , else)

The alt function returns the first of the parameters that has a valid number representation. If no such match is found, the last parameter will be returned. Any number of parameters can be used.

Regards

ASHFAQ

Re: NULL as a data point in qlikview

alexandros17 — Mon, 27 Oct 2014 09:28:32 GMT

In the dimension of your PieChart try this:

If(isnull([Team Name]), 'NULL VALUES', [Team Name])

DO NOT suppress values where value is null

Let me know

Re: NULL as a data point in qlikview

ashfaq_haseeb — Mon, 27 Oct 2014 09:29:00 GMT

You can even check this for null handling.

http://community.qlik.com/docs/DOC-3155

Regards

ASHFAQ

Re: NULL as a data point in qlikview

tresB — Mon, 27 Oct 2014 09:31:12 GMT

In the presentation tab-> Set Null symbol 'NULL'

Re: NULL as a data point in qlikview

Mon, 27 Oct 2014 09:37:17 GMT

does not work

Re: NULL as a data point in qlikview

alexandros17 — Mon, 27 Oct 2014 09:40:34 GMT

Start from your table (is it a chart?) then transform it in a pie chart, what happen?

Let me know

Re: NULL as a data point in qlikview

anbu1984 — Mon, 27 Oct 2014 09:59:46 GMT

Can you post sample app

Re: NULL as a data point in qlikview

Anonymous — Mon, 27 Oct 2014 20:52:30 GMT

Anbu

Have look at using NullAsValue in the load script, Help text for it pasted in below.

NullAsValue

The NullAsValue statement specifies for which fields the encountered NULLs should be converted to values.

By default, QlikView considers NULL values to be missing or undefined entities. However, certain database contexts imply that NULL values are to be considered as special values rather than simply missing values. The fact that NULL values are normally not allowed to link to other NULL values can be suspended by means of the NullAsValue statement.

The NullAsValue statement operates as a switch and will operate on subsequent loading statements. It can be switched off again by means of the NullAsNull statement.

The NullAsValue can be combined with the variable NullValue that specifies which string to use as NULL value. If the variable NullValue is not used, NullAsValue will replace NULLs with empty strings.

The syntax is:

NullAsValue*fieldlist

*fieldlist is a comma separated list of the fields for which NullAsValue should be turned on. Using * as field list indicates all fields. The wildcard characters * and ? are allowed in field names. Quoting of field names may be necessary when wildcards are used.

Example:

NullAsValue A,B;

Set NullValue = 'NULL' ;

Load A,B from x.csv;