Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

Value to Ratio with text


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?

1 Reply
New Contributor

Re: Value to Ratio with text

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