Pivot Chart Multiple values with NULL exception

[bandarjm]

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 

[tincholiver]

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))

[tincholiver · Accepted solution]

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

[bandarjm]

Thank you. it worked for me.