Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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]))

Highlighted
Creator III
Creator III

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

Highlighted
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])) ?

Highlighted

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

Highlighted
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]))

Highlighted
Creator III
Creator III

never mind, I made comparison on backend. Thanks