Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bandarjm
New Contributor II

Pivot Chart Multiple values with NULL exception

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 

CaptureQlik.JPG

Tags (2)
1 Solution

Accepted Solutions
tincholiver
Contributor II

Re: Pivot Chart Multiple values with NULL exception

one more thing, in the presentation tab uncheck the box delete zero values
3 Replies
tincholiver
Contributor II

Re: Pivot Chart Multiple values with NULL exception

Hi Bandarjm,

The solution:

Nulls in flags.png

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
Contributor II

Re: Pivot Chart Multiple values with NULL exception

one more thing, in the presentation tab uncheck the box delete zero values
bandarjm
New Contributor II

Re: Pivot Chart Multiple values with NULL exception

Thank you. it worked for me.