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.
-> 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?