NULL as a data point in qlikview

[#1]

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?

[Gysbert_Wassenaar]

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

[#3]

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

[ashfaq_haseeb]

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

[alexandros17]

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

[ashfaq_haseeb]

You can even check this for null handling.

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

Regards

ASHFAQ

[tresesco]

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

[#8]

does not work

[alexandros17]

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

Let me know

[anbu1984]

Can you post sample app