Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a column of numbers rounded to the nearest tenth. I want to take that number and convert it to a fraction (simplified) and then turn that into a ratio with text.
Ex:
2.2
-> Convert to Fraction: 22/10
-> Simplify: 11/5
-> Create Ratio: 11 Apples to 5 Oranges (apples to oranges for example, might want to have a price ratio such as 15 lasers to 4 dollars)
Anyone know the QlikSense code that would allow me to do this?
My end goal is to take a decimal value and be able to write a ratio (most simplified) for it.
Ex: .25 becomes 1 to 4