topic Re: Aggr Expression in QlikView

Aggr Expression

Anonymous — Wed, 28 Jun 2017 18:29:05 GMT

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

Re: Aggr Expression

sunny_talwar — Wed, 28 Jun 2017 18:31:51 GMT

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

Re: Aggr Expression

Anonymous — Wed, 28 Jun 2017 19:39:55 GMT

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

Re: Aggr Expression

Anonymous — Wed, 28 Jun 2017 21:31:57 GMT

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

Re: Aggr Expression

sunny_talwar — Wed, 28 Jun 2017 23:22:24 GMT

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

Re: Aggr Expression

Kushal_Chawda — Thu, 29 Jun 2017 07:17:58 GMT

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

Re: Aggr Expression

Anonymous — Thu, 29 Jun 2017 22:15:24 GMT

never mind, I made comparison on backend. Thanks