Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Partner
Partner

Set analysis shows correct value when nulls enabled

Hello!

I'm having an issue where  If I Enable the show null values for my date field the values show correctly in a pivot table , without the nulls it does not.. (is there a way to add in nulls in the value without enabling?)

No issue in a text object though.  Here is the expression

COUNT(DISTINCT{<AuthorizedSheet = P($::Sheet),Sheet=> } TOTAL<EmployeeStaffLevelDescription,Practice>[clientUniqueIdentifier.userId])

Thank you !

Without Nulls

MonthOct-2019Sep-2019Aug-2019Jul-2019
Staff LevelAuthorized UsersAuthorized UsersAuthorized UsersAuthorized Users
Totals7,7707,7707,7707,770
Administration1,2081,2081,2081,208
Associate16161616
Manager1,2331,2331,2331,233
Managing Director889889889889
Paraprofessional5555
Partner1,9151,9151,9151,915
Senior Associate53535353
Sr. Manager / Director2,4512,4512,4512,451
 

With Nulls

 

Month-Oct-2019Sep-2019Aug-2019
Staff LevelAuthorized UsersAuthorized UsersAuthorized UsersAuthorized Users
Totals11,99211,99211,99211,992
-36363636
Administration1,5541,5541,5541,554
Associate34343434
Manager2,7832,7832,7832,783
Managing Director1,0861,0861,0861,086
Paraprofessional7777
Partner2,2482,2482,2482,248
Senior Associate131131131131
Sr. Manager / Director4,1134,1134,1134,113
 
 
 
4 Replies

Re: Set analysis shows correct value when nulls enabled

May be this

Count(DISTINCT {<AuthorizedSheet = P($::Sheet), Sheet, [Staff Level] *= {"*"}, Month *= {"*"}>} TOTAL <EmployeeStaffLevelDescription, Practice> clientUniqueIdentifier.userId])

 

Partner
Partner

Re: Set analysis shows correct value when nulls enabled

Showing Same results

Re: Set analysis shows correct value when nulls enabled

Would you be able to share a sample where we can see the issue?

Partner
Partner

Re: Set analysis shows correct value when nulls enabled

wont be able to but let me see if i can share something with you that can help in further investigating.  Thanks!