Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Romstar111
New Contributor II

Including null values from one dimension in Qlik sense

Hi there, 

I was wondering if anyone in this network could help. I am trying to include null values in my set analysis without luck. Even trying with count if brought no joy. I have checked other similar examples but it seems Qilk sense is tricky with null values. The data is imported from Salesforce and the Salesforce report is accurate but not in Qlik sense.

I have tried the following:

Count({<

Status={
'Application In Progress',
'Application Submitted',
'Offer Conditional',
'Offer Made',
'Offer unconditional',
'Offer Accepted',
'Active',
'Final Preparation',
'Completed',
'Assessment Scheduled',
'Recommended for QTS',
'Deferred',
'Rejected',
'Withdrawn',
"*"}
>}Id)

 

 

and

 

count(if(match(
Stage_Status__c ,
'Application In Progress',
'Application Submitted',
'Offer Conditional',
'Offer Made',
'Offer unconditional',
'Offer Accepted',
'Active',
'Final Preparation',
'Completed',
'Assessment Scheduled',
'Recommended for QTS',
'Deferred',
'Rejected',
'Withdrawn',
''),
Opportunity_Id))

1 Solution

Accepted Solutions
Romstar111
New Contributor II

Re: Including null values from one dimension in Qlik sense

Solved!

 

I had to force qlik sense to accept null values from the load script.

e.g 

NullAsValue A,B;

Set NullValue = 'NULL'; 

More resources on this from the following: https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegular...

 

Thanks guys for your help. 🙂

5 Replies
Partner
Partner

Re: Including null values from one dimension in Qlik sense

try below expression

Count({<

Status={
'Application In Progress',
'Application Submitted',
'Offer Conditional',
'Offer Made',
'Offer unconditional',
'Offer Accepted',
'Active',
'Final Preparation',
'Completed',
'Assessment Scheduled',
'Recommended for QTS',
'Deferred',
'Rejected',
'Withdrawn'}
>
+ <Id={"=isnull(Status)"}>
}Id)

i am assuming you want these statuses or null

Channa
Valued Contributor III

Re: Including null values from one dimension in Qlik sense

if (isnull(Status) or pick(match('Application In Progress',
'Application Submitted',
'Offer Conditional',
'Offer Made',
'Offer unconditional',
'Offer Accepted',
'Active',
'Final Preparation',
'Completed',
'Assessment Scheduled',
'Recommended for QTS',
'Deferred',
'Rejected',
'Withdrawn'),count(ststus)

Channa
Romstar111
New Contributor II

Re: Including null values from one dimension in Qlik sense

Hey  

Thank you for your help but it is not working. Fore some reason it just add an extra layer of the null values on top an extra 15 in the count value.

Romstar111
New Contributor II

Re: Including null values from one dimension in Qlik sense

Hi Channa, This is not working unfortunately. Not returning a value.

Romstar111
New Contributor II

Re: Including null values from one dimension in Qlik sense

Solved!

 

I had to force qlik sense to accept null values from the load script.

e.g 

NullAsValue A,B;

Set NullValue = 'NULL'; 

More resources on this from the following: https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegular...

 

Thanks guys for your help. 🙂