topic Re: How to get ratio like X:Y in QlikView

How to get ratio like X:Y

tresB — Mon, 23 Sep 2013 15:44:40 GMT

Hello Everybody,

I need to show ratio of two numbers in x:y format(proper fraction). Had there been a system function like GCD(Greatest Common Divisor) in excel, I could get it easily. But, without that does anybody have any idea? In excel, the TEXT() function can be used as an alternative as that lets passing some formatting parameter, but unfortunately, even that is not possible in qv.

Input: 21, 56

Expected output : 3:8

Any idea would be greatly appreciated.

@Qlikview Development Team, - Please consider to incorporate a system function for GCD.

Thanks,

tresesco

Re: How to get ratio like X:Y

Mon, 23 Sep 2013 18:16:32 GMT

So you want the GCD or the fraction simplified?

Re: How to get ratio like X:Y

v_iyyappan — Mon, 23 Sep 2013 20:09:47 GMT

Hi,

Please check following link to find the GCD.

How to calculate the GCD(Greatest Common divisor)

Regards,

Re: How to get ratio like X:Y

tresB — Tue, 24 Sep 2013 04:10:48 GMT

Give me idea of any of them.

Re: How to get ratio like X:Y

tresB — Tue, 24 Sep 2013 04:12:18 GMT

I had checked that, that does not help in front-end calculation.

Re: How to get ratio like X:Y

Narband — Tue, 22 Jun 2021 16:08:02 GMT

Hi,

Had any Luck with this !!

From,

Naresh

Re: How to get ratio like X:Y

Flannery — Thu, 24 Jun 2021 06:06:54 GMT

Let's say the ratio of cats to dogs is 3:2. There are 30 animals total. Find the number of cats. How do you do a problem like this?