6 Replies Latest reply: Jan 26, 2015 3:33 AM by Massimo Grossi RSS

    Displaying a number as a proportion please help.

      Hello. I am new to QlikView and I am trying to reproduce a box like the one shown in the picture attached.

      First I am not even sure what object I should Use. I have been using text objects and for this one I have a formula as follows.


      =Count(if(Program = 'DETECT STOP',1)) / sum(If(Program <> 'DETECT STOP', PartsProduced))


      But I get a decimal representation and I want a fraction.


      Any help on the object and setting I need to choose or even add/change code would be appreciated.