https://community.qlik.com/t5/QlikView/ratio/m-p/1572453#M741186 <P>You have to use macros here and create a GCD(Greatest Common Divisor) function.</P><P>Please find the macro in the below link</P><P><A href="https://community.qlik.com/t5/New-to-QlikView/Ratio/td-p/868157" target="_blank">https://community.qlik.com/t5/New-to-QlikView/Ratio/td-p/868157</A></P> Wed, 24 Apr 2019 06:27:23 GMT arpitkharkia 2019-04-24T06:27:23Z https://community.qlik.com/t5/QlikView/ratio/m-p/1572414#M741184 <P>hello Qlik builders, i am looking fo rsome logic (function / code) that given to integers will return a ratio, e.g.</P><P>4 and 2 would return 2 : 1</P><P>12 and 8 and would return 3 : 2</P><P>35 and 25 would return 7 : 5</P><P>...</P><P>not as easy as you might think !</P> Sat, 16 Nov 2024 03:46:55 GMT https://community.qlik.com/t5/QlikView/ratio/m-p/1572414#M741184 cspindley 2024-11-16T03:46:55Z https://community.qlik.com/t5/QlikView/ratio/m-p/1572416#M741185 <P>How this value returns?</P><P>35 and 25 would return 7 : 5 -- If output you need as 3.5 : 2.5 (We can achieve). If logic different, please explain the logic too.</P> Wed, 24 Apr 2019 05:12:41 GMT https://community.qlik.com/t5/QlikView/ratio/m-p/1572416#M741185 Anil_Babu_Samineni 2019-04-24T05:12:41Z https://community.qlik.com/t5/QlikView/ratio/m-p/1572453#M741186 <P>You have to use macros here and create a GCD(Greatest Common Divisor) function.</P><P>Please find the macro in the below link</P><P><A href="https://community.qlik.com/t5/New-to-QlikView/Ratio/td-p/868157" target="_blank">https://community.qlik.com/t5/New-to-QlikView/Ratio/td-p/868157</A></P> Wed, 24 Apr 2019 06:27:23 GMT https://community.qlik.com/t5/QlikView/ratio/m-p/1572453#M741186 arpitkharkia 2019-04-24T06:27:23Z