topic Re: Ratio in QlikView

Ratio

Tue, 07 Apr 2015 12:47:04 GMT

Hello

How do I create a ratio (not as a percentage)...

For example, I have a sales value of 1754 and a demo value of 764

How can I display the sales:demo ratio (1754 : 764) in its lowest form?

Many thanks

Re: Ratio

Gysbert_Wassenaar — Tue, 07 Apr 2015 12:51:07 GMT

dual( sales_value & ' : ' & demo_value, sales_value/demo_value)

Or are you asking how to calculate the greatest common divisor? There's no Qlikview function to do that. You'll have to calculate it before hand or use a macro.

Re: Ratio

sunny_talwar — Tue, 07 Apr 2015 12:56:14 GMT

But gwassenaar‌ this won't be in its lowest form. The lowest form would be displaying it as 877:382

Am I correct sabahsdada ? This is what you are looking to do???

Re: Ratio

Tue, 07 Apr 2015 13:07:33 GMT

Yes you are right, I need to see this value in its lowest form

Re: Ratio

sunny_talwar — Tue, 07 Apr 2015 13:47:24 GMT

Still looking for ways to achieve what you wanted, but have been unsuccessful so far. Came across this link: ‌, where you can vote for a function which can help you with what you are trying to achieve.

HTH

Best,

Sunny

Re: Ratio

mjayachandran — Tue, 07 Apr 2015 13:56:27 GMT

you can try doing it in the script.

see the link below:

How to calculate the GCD(Greatest Common divisor)

once you have the gcd value, then u can use the formula,

=salesvalue/GCDfield &":"&demovalue/GCDfield

Hope it helps

Re: Ratio

sunny_talwar — Tue, 07 Apr 2015 13:57:16 GMT

Used a macro to achieve what you wanted (Found the macro here: How to calculate the GCD(Greatest Common divisor))

Please find attached the application and see if this is helpful.

Best,

Sunny

Re: Ratio

vvvvvvizard — Tue, 07 Apr 2015 16:25:31 GMT

='1 : '&round( demo_value/sales_value ,2)