Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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?