Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

NULL as a data point in qlikview

Here are the first three rows of my data

Team NameRole Count
A10
B10
NULL11

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?

10 Replies
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


talk is cheap, supply exceeds demand
Not applicable
Author

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

ashfaq_haseeb
Champion III
Champion III

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
Partner - Champion III
Partner - Champion III

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
Champion III
Champion III

You can even check this for null handling.

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

Regards

ASHFAQ

tresesco
MVP
MVP

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

Not applicable
Author

does not work

alexandros17
Partner - Champion III
Partner - Champion III

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

Let me know

anbu1984
Master III
Master III

Can you post sample app