Pie chart unable to select item with NULL values?

Anonymous — Mon, 30 Oct 2017 07:44:26 GMT

People:

LOAD * INLINE [

Name, Age

Adam, 34

Bonnie, 25

Charlie, 56

David, 34

Eddy, 34

Florence, 45

Gale, 43

Helen, 24

Isabella, 37

Jamie, 54

Kelvin, 25

];

Children:

LOAD * INLINE [

Child, Name

Lyra, Adam

Matt, Bonnie

Norman, Bonnie

Oliva, Eddy

Peter, Isabella

Qweenie, Helen

Roger, Helen

Steven, Jamie

Umar, Jamie

Victor, Jamie

Walter, Kelvin

Xavier, Kelvin

Zeldar, Kelvin

];

With the above 2 tables, I created a Pie Chart to show ratio of people with kids vs people with no kids using a Calculated Dimension:

=if(len(Child) <> 0, 'People with Kids', 'People without Kids')

and Expression:

Count(DISTINCT Name)

However, I am able to filter people with kids by selecting on the Pie chart but not able to filter people with No Kids.

Anyone can help? Or have I approached this all wrong?

Re: Pie chart unable to select item with NULL values?

devarasu07 — Mon, 30 Oct 2017 10:33:13 GMT

Hi,

Try like below,

People:

LOAD * INLINE [

Name, Age

Adam, 34

Bonnie, 25

Charlie, 56

David, 34

Eddy, 34

Florence, 45

Gale, 43

Helen, 24

Isabella, 37

Jamie, 54

Kelvin, 25

];

left join

//Children:

LOAD * INLINE [

Child, Name

Lyra, Adam

Matt, Bonnie

Norman, Bonnie

Oliva, Eddy

Peter, Isabella

Qweenie, Helen

Roger, Helen

Steven, Jamie

Umar, Jamie

Victor, Jamie

Walter, Kelvin

Xavier, Kelvin

Zeldar, Kelvin

];

Final:

load *,if(len(Child)<0 or IsNull(Child), 'People without Kids','People with Kids') as ChildStatus Resident People;

drop table People;

topic Pie chart unable to select item with NULL values? in QlikView

Pie chart unable to select item with NULL values?

Re: Pie chart unable to select item with NULL values?