1 Reply Latest reply: Jul 17, 2017 7:22 PM by Neil Fernandes RSS

    Value to Ratio with text

    Neil Fernandes



      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?