topic Re: Pivot Chart Multiple values with NULL exception in QlikView

Pivot Chart Multiple values with NULL exception

bandarjm — Wed, 25 Nov 2020 16:16:04 GMT

Need your expert Suggestions and Solution. as Shown below, What I need is, if a column with multiple flag with NULL, I need to say Not req, if standalone null, then req. Suppress Null when Multiple Values in the column Flag .

I am using Pivot chart. wondering if i need to handle it at query level. suggest

Re: Pivot Chart Multiple values with NULL exception

tincholiver — Wed, 06 Mar 2019 00:28:07 GMT

Hi Bandarjm,

The solution:

For this:

LOAD in your script;

Table:
LOAD * Inline
[Name, flag
Tom, NULL
Tom, 1
Tom, 0
Pam, NULL
Matt, 1
Matt, 0
Scott, NULL
Scott, 1
Van, NULL
];

LOAD
Name,
Count(flag) as Flags
Resident Table Group by Name;

and in the table

Dimension:

Name

flag

Expression:

if(Flags=1 and flag='NULL','Req',
if(Flags>1 and flag='NULL','No Req',flag))

Re: Pivot Chart Multiple values with NULL exception

tincholiver — Wed, 06 Mar 2019 00:31:27 GMT

one more thing, in the presentation tab uncheck the box delete zero values

Re: Pivot Chart Multiple values with NULL exception

bandarjm — Thu, 07 Mar 2019 20:05:16 GMT

Thank you. it worked for me.