QlikView App Dev

[nagarwal]

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]

May be try like this

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

[sunny_talwar · Accepted solution]

May be this

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

[nagarwal]

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