topic Expressions calculation in QlikView

Expressions calculation

Mon, 17 Aug 2015 08:44:45 GMT

Hi Experts

in my qvw i am calculating AREAMANAGER count against REGIONMANAGER to calculate targets

i am using this expression to count that

=SUM(AGGR(AREAMANAGER,REGIONMANAGER,BUSINESSMANAGER,BRANCHNAME))

the values yielding are correct but there is a new condition like if AREAMANAGER count exceeds 19 for a REGIONMANAGER then it should write as 19

i have two REGIONMANAGER exceeding 19 AREAMANAGER

how can i change this expression

please suggest

Re: Expressions calculation

sunny_talwar — Mon, 17 Aug 2015 08:46:45 GMT

May be this:

=If(SUM(AGGR(AREAMANAGER,REGIONMANAGER,BUSINESSMANAGER,BRANCHNAME)) >= 19, 19, =SUM(AGGR(AREAMANAGER,REGIONMANAGER,BUSINESSMANAGER,BRANCHNAME)))

Re: Expressions calculation

sasiparupudi1 — Mon, 17 Aug 2015 08:59:10 GMT

if (AGGR(count(AREAMANAGER),REGIONMANAGER)>=19,19,SUM(AGGR(AREAMANAGER,REGIONMANAGER,BUSINESSMANAGER,BRANCHNAME)))

Re: Expressions calculation

Mon, 17 Aug 2015 09:54:08 GMT

HI Sunny

Thanks

=If(SUM(AGGR(AREAMANAGER,REGIONMANAGER,BUSINESSMANAGER,BRANCHNAME)) >= 19, 19, SUM(AGGR(AREAMANAGER,REGIONMANAGER,BUSINESSMANAGER,BRANCHNAME)))

after removing the = it worked perfect

Expressions calculation