topic Evaluating Expression in Set Analysis in QlikView

Evaluating Expression in Set Analysis

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

Hello,

I have a requirement where I calculate Audit count of the sheet using below expression

Sum ({<AuditTimestamp={"*"}, AuditType={'Sheet'}>} Audit_Count

now I want to count the sheet id's for which the Sum of Audit Count is greater then 0. something like below expression

Count({< (Sum ({<AuditTimestamp={"*"}, AuditType={'Sheet'}>} Audit_Count) > 0 >} Sheet ID)

Could you please help me to correct above expression

arpitkharkia — Tue, 16 Apr 2019 11:36:56 GMT

May be try like this

if(Sum ({<AuditTimestamp={"*"}, AuditType={'Sheet'}>} Audit_Count)>0,count(sheetID))

sunny_talwar — Tue, 16 Apr 2019 11:40:28 GMT

May be this

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

nagarwal — Tue, 16 Apr 2019 12:03:53 GMT

Thanks Sunny. It Worked perfect Just Added DISTINCT and got my solution.