topic showing fraction in chart/table in QlikView

showing fraction in chart/table

raghavsurya — Mon, 13 Feb 2012 11:02:39 GMT

Hi All,

We have a client requirement wherein we have to show the value in Fractions for example "3/4", 3:4. Can anyone suggest how to present this number format.

Thanks and Regards,

Raghav

showing fraction in chart/table

Jason_Michaelides — Mon, 13 Feb 2012 11:18:05 GMT

Do you mean you have an underlying number of 0.75 and want display as 3/4?

showing fraction in chart/table

raghavsurya — Mon, 13 Feb 2012 11:25:44 GMT

Hi Jason,

Yes. This is exactly my requirement.

Thanks and Regards,

Raghav

showing fraction in chart/table

Jason_Michaelides — Mon, 13 Feb 2012 11:46:53 GMT

Wow. This goes a little beyond simple formatting! x/y = z where z is a decimal number. You want x and y when all you know is z!

I suggest you Google about for the solution to this, Raghav. A quick look showed me you need to do this in two steps. The first (described here - http://www.mathsisfun.com/converting-decimals-fractions.html) could be automated in the QlikView script easily enough. The second (simplifying 75/100 to 3/4) is a manual process, however, and unless you can find a formula for this (I don't know one!) then I think you'll struggle...

Sorry,

Jason