topic Re: Set analysis shows correct value when nulls enabled in QlikView

Set analysis shows correct value when nulls enabled

arazadisqr — Thu, 24 Oct 2019 18:12:58 GMT

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

Month	Oct-2019	Sep-2019	Aug-2019	Jul-2019
Staff Level	Authorized Users	Authorized Users	Authorized Users	Authorized Users
Totals	7,770	7,770	7,770	7,770
Administration	1,208	1,208	1,208	1,208
Associate	16	16	16	16
Manager	1,233	1,233	1,233	1,233
Managing Director	889	889	889	889
Paraprofessional	5	5	5	5
Partner	1,915	1,915	1,915	1,915
Senior Associate	53	53	53	53
Sr. Manager / Director	2,451	2,451	2,451	2,451

With Nulls

Month	-	Oct-2019	Sep-2019	Aug-2019
Staff Level	Authorized Users	Authorized Users	Authorized Users	Authorized Users
Totals	11,992	11,992	11,992	11,992
-	36	36	36	36
Administration	1,554	1,554	1,554	1,554
Associate	34	34	34	34
Manager	2,783	2,783	2,783	2,783
Managing Director	1,086	1,086	1,086	1,086
Paraprofessional	7	7	7	7
Partner	2,248	2,248	2,248	2,248
Senior Associate	131	131	131	131
Sr. Manager / Director	4,113	4,113	4,113	4,113

Re: Set analysis shows correct value when nulls enabled

sunny_talwar — Thu, 24 Oct 2019 18:57:48 GMT

May be this

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

Re: Set analysis shows correct value when nulls enabled

arazadisqr — Thu, 24 Oct 2019 19:17:51 GMT

Showing Same results

Re: Set analysis shows correct value when nulls enabled

sunny_talwar — Thu, 24 Oct 2019 19:42:05 GMT

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

Re: Set analysis shows correct value when nulls enabled

arazadisqr — Fri, 25 Oct 2019 14:10:03 GMT

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