topic Comparing points between 2 metrics in script ... in QlikView

Comparing points between 2 metrics in script ...

Wed, 25 Nov 2020 16:16:04 GMT

So..I have 2 metrics as below

Target : 3.8

Actual : ((sum(Cost * 100)/sum(Revenue)))

and below is my metrics...I am messing up with parentheses here..can anyone help me..

if((sum(Cost * 100)/sum(Revenue)) < = '3.8',5,

if(((sum(Cost * 100)/sum(Revenue)) > 0 and (sum(Cost * 100)/sum(Revenue))) <= '4',3,

if((sum(Cost * 100)/sum(Revenue)) > '4.1' ,1 ))) as [Real Estate Rate]

Thanks much

Anil_Babu_Samineni — Fri, 26 Aug 2016 16:20:49 GMT

Can you please let me know

You want Cost * 100 of sum OR Sum(Cost)*100 ??

vishsaggi — Fri, 26 Aug 2016 16:53:17 GMT

May be this:

= if((sum(Cost)/sum(Revenue)) * 100 <= 3.8, 5,

if((sum(Cost)/sum(Revenue)) * 100 > 0 and (sum(Cost)/sum(Revenue))*100 <= 4, 3,

if((sum(Cost)/sum(Revenue)) * 100 > 4.1 ,1 ))) as [Real Estate Rate]

sunny_talwar — Fri, 26 Aug 2016 16:56:18 GMT

This seems like something which is done in the script... because of the as [Real Estate Rate]. Are you using Group by?