Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bandarjm
Contributor II
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

1 Solution

Accepted Solutions
tincholiver
Creator III
Creator III

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

View solution in original post

3 Replies
tincholiver
Creator III
Creator III

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
Creator III
Creator III

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

Thank you. it worked for me.