topic Re: Pie chart advanced functionality issues in QlikView

Pie chart advanced functionality issues

Marcushenriquesk — Tue, 01 Feb 2022 15:21:56 GMT

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?

Re: Pie chart advanced functionality issues

chrismarlow — Tue, 01 Feb 2022 17:14:45 GMT

Hi,

Maybe a calculated dimension like;

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

With single measure Count(ACC_ID)

Cheers,

Chris.

Re: Pie chart advanced functionality issues

Marcushenriquesk — Wed, 02 Feb 2022 14:38:59 GMT

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.

Re: Pie chart advanced functionality issues

Marcushenriquesk — Wed, 02 Feb 2022 15:06:12 GMT

=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

Re: Pie chart advanced functionality issues

chrismarlow — Wed, 02 Feb 2022 15:28:03 GMT

Hi,

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

Cheers,

Chris.

Re: Pie chart advanced functionality issues

Marcushenriquesk — Wed, 02 Feb 2022 16:04:41 GMT

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

Re: Pie chart advanced functionality issues

Marcushenriquesk — Wed, 02 Feb 2022 16:07:15 GMT

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'

Re: Pie chart advanced functionality issues

Marcushenriquesk — Wed, 02 Feb 2022 16:09:56 GMT

here is example data that im working with.

Re: Pie chart advanced functionality issues

Marcushenriquesk — Tue, 08 Feb 2022 16:02:28 GMT

can you please help me close out this issue?

Re: Pie chart advanced functionality issues

chrismarlow — Tue, 08 Feb 2022 18:55:36 GMT

Hi,

Think an error in my formula, try;

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

Cheers,

Chris.