Pie chart advanced functionality issues

[Marcushenriquesk]

Hello, 

I am developing a sheet in QlikSense app editor which contains a pie chart. In this pie chart i want to display the amount of samples we received that have a 'External_no' = null and the amount of samples we received with 'external_no' = Not null. So there should only be two slices using one table. the table has a primary key 'ACC_ID' and a field associated within the same table 'External_No'. I dont know how to create this visual without having multiple measures. how do i go about completing this task? 

[chrismarlow]

Hi,

Maybe a calculated dimension like;

If(External_no = null, 'Null', 'Not Null')

With single measure Count(ACC_ID)

Cheers,

Chris.

[Marcushenriquesk]

i tried that but its saying if only takes two parameters. also external_no = null and external_no = some value. are the two main slices. since external_no can have many different values this doesnt split it to just two slices.

[Marcushenriquesk]

=if((EXTERNAL_NO = ''),'Manual', 'Electronic') i tried this but only elecctronic records showing. even though i know there are a plenty null values for 'manual' i even checked on a table i made

[chrismarlow]

Hi,

I was thinking of something like this, but not sure I understand what you meant (looking at your later posts).

Cheers,

Chris.

[Marcushenriquesk]

this works great, but how do i change the title of the slices?

[Marcushenriquesk]

wait i tried it and same issue. all of them are appearing to have a value or 100% is not null. even though on a table view i can see many null values for each 'ACC_ID'

[Marcushenriquesk]

here is example data that im working with.

[Marcushenriquesk]

can you please help me close out this issue?

[chrismarlow · Accepted solution]

Hi,

Think an error in my formula, try;

=if(IsNull(EXTERNAL_NO) or EXTERNAL_NO='','Null','Not Null')

Cheers,

Chris.