Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
nagarwal
Partner - Contributor II
Partner - Contributor II

SET Analysis Issue

Hello,

I am having a field in table for which i am using below expression

Count(DISTINCT{<[AuditSheetLabel] = {"=Sum({<AuditTimestamp = {[*]}, AuditType ={'Sheet'}>} Audit_Count) > 0"}>} [AuditSheetLabel])

so what happening here is this expression doesnt give me proper output but once I select any record from the table it gives me proper output.

could you please tell me what am I missing here.

 

1 Reply
nagarwal
Partner - Contributor II
Partner - Contributor II
Author

Got the answer it was including null values also so I changed the expression as below and it worked

Count(DISTINCT{<[AuditSheetLabel] = {"=Sum({<AuditTimestamp = {[*]}, AuditType ={'Sheet'},[AuditSheetLabel]-={[-]} >} Audit_Count) > 0"}>} [AuditSheetLabel])

but still I am not sure while selecting any particular record why it was not taking null values count?

can anybody help me out please?