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.

       

       

       

      Proportion.jpg