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

    Value to Ratio with text

    Neil Fernandes

      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?