topic Re: Expression Help in QlikView

Expression Help

Mon, 17 Aug 2015 10:04:20 GMT

Hi Experts

in my qvw i am calculating targets

i am using this expression to count the number of AREAMANAGER against REGIONMANAGER

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

the values yielding are correct but there is a condition like if AREAMANAGER count exceeds 19 for aREGIONMANAGER then it writes 19 correctly

now i have to calculate the SPD targets for each AREAMANAGER, even if his branch count exceeds 19 then it should show the targets only for count of 19 branches

My expression is

=SUM(AGGR([SPD Target],REGIONMANAGER,BUSINESSMANAGER,BRANCHNAME))

Please Suggest

Re: Expression Help

MK_QSL — Mon, 17 Aug 2015 10:05:52 GMT

Provide sample app or sample data to work with your expected output.

Re: Expression Help

sunny_talwar — Mon, 17 Aug 2015 10:24:17 GMT

Not entirely sure you are trying to achieve here. As Manish suggest, sample data as well as expected output would be helpful in providing information about your requirement.

Best,

Sunny

Re: Expression Help

Mon, 17 Aug 2015 10:33:55 GMT

Please Find the Data & the Qvw attached

the target against 5561,5562,5563,5564 should be 6270

Please Suggest

Re: Expression Help

MK_QSL — Mon, 17 Aug 2015 10:46:50 GMT

For Count

=IF(COUNT(DISTINCT AREAMANAGER_ID)>=19,19,COUNT(DISTINCT AREAMANAGER_ID))

For Target

=IF(COUNT(DISTINCT AREAMANAGER_ID)>=19,19,COUNT(DISTINCT AREAMANAGER_ID))*Only([SPD Target])