Set Analysis issue

nirajagarwal — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Set Analysis issue

lfetensini — Wed, 24 Apr 2019 16:58:30 GMT

Remove {[*]} from AuditTimestamp

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

topic Re: Set Analysis issue in QlikView

Set Analysis issue

Re: Set Analysis issue