topic Rato Calculation straight Table in QlikView https://community.qlik.com/t5/QlikView/Rato-Calculation-straight-Table/m-p/255644#M96745 <HTML><HEAD></HEAD><BODY><P>hi experts</P><P></P><P>sum(x)=10</P><P>sum(y)=20</P><P></P><P>i need to display 10:20&nbsp; as 1:2 in straight table</P><P></P><P>how can i achieve with expression</P><P></P><P></P><P>thanks in Advancd</P></BODY></HTML> Fri, 06 Jan 2012 05:57:41 GMT 2012-01-06T05:57:41Z Rato Calculation straight Table https://community.qlik.com/t5/QlikView/Rato-Calculation-straight-Table/m-p/255644#M96745 <HTML><HEAD></HEAD><BODY><P>hi experts</P><P></P><P>sum(x)=10</P><P>sum(y)=20</P><P></P><P>i need to display 10:20&nbsp; as 1:2 in straight table</P><P></P><P>how can i achieve with expression</P><P></P><P></P><P>thanks in Advancd</P></BODY></HTML> Fri, 06 Jan 2012 05:57:41 GMT https://community.qlik.com/t5/QlikView/Rato-Calculation-straight-Table/m-p/255644#M96745 2012-01-06T05:57:41Z Rato Calculation straight Table https://community.qlik.com/t5/QlikView/Rato-Calculation-straight-Table/m-p/255645#M96746 <HTML><HEAD></HEAD><BODY><P>It would be useful, to help better, to know what's the use for... </P><P>anyway, try:</P><P></P><P>'1:'&amp;sum(y)/sum(x)</P><P></P><P>in your example, you get an inter ratio, with 1 as numerator</P><P>perhaps you need a solution for more complex values (i.e.: sum(x)=35,8 and sum(y)=0,23): wath would you expect to see in this cases ?</P></BODY></HTML> Sat, 07 Jan 2012 04:07:04 GMT https://community.qlik.com/t5/QlikView/Rato-Calculation-straight-Table/m-p/255645#M96746 robertomontanar 2012-01-07T04:07:04Z