Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Aggr Expression

Can't identify where am I going wrong here!

Each ratio that belongs to DQ name should be compared with Threshold  of DQ Name and count how many satisfied.

if(Aggr((sum({<[LOB={'CMB'}>}[Rule Met Count])
/
sum({<[LOB]={'CMB'}>}[Total Count])),[DQ Name])>aggr(only(Threshold),[DQ Name]),count([DQ Name]))

6 Replies

May be you need this

=Count(Aggr(If((Sum({<[LOB={'CMB'}>}[Rule Met Count])/Sum({<[LOB]={'CMB'}>}[Total Count])) > Only(Threshold), [DQ Name]),[DQ Name]))

Creator III
Creator III

This result varies with LOB =CMB selection and with out CMB .

Creator III
Creator III

Thresholds are different for each DQ Name, will different thresholds apply to each result of Sum({<[LOB={'CMB'}>}[Rule Met Count])/Sum({<[LOB]={'CMB'}>}[Total Count])) ?

Not sure I understand, do you have a sample you can share maybe?

MVP
MVP

may be this

sum(Aggr(count(if(Aggr((sum({<[LOB={'CMB'}>}[Rule Met Count])
/
sum({<[LOB]={'CMB'}>}[Total Count])),[DQ Name])>aggr(only(Threshold),[DQ Name]),[DQ Name])),[DQ Name]))

Creator III
Creator III

never mind, I made comparison on backend. Thanks