Qlik Community

Qlik Sense App Development

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
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
Highlighted
Contributor II
Contributor II

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. 🙂

View solution in original post

5 Replies
Highlighted
Partner
Partner

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

Highlighted
Specialist III
Specialist III

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

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.

Highlighted
Contributor II
Contributor II

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

Highlighted
Contributor II
Contributor II

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. 🙂

View solution in original post