Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
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