showing fraction in chart/table

[raghavsurya]

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

[Jason_Michaelides]

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

[raghavsurya]

Hi Jason,

Yes.  This is exactly my requirement. 

Thanks and Regards,

Raghav

[Jason_Michaelides]

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