2 Replies Latest reply: Nov 1, 2017 5:54 PM by Fer Fer RSS

    Need help in converting percentage into value

    Bharath Vikas Shanagonda

      Hi,

       

      I need some help in the percentage value. Basically I have created a table in Qlikview which has an expression which calculate percentage and I want an expression which gives the value of that percentage. For example if the percentage is 69% and I want an expression which gives value of 69% in another column.

       

      Below is the example table which I've created and the expressions which I'm using to get the percentage value.

       

      TechnologyTotal DevicesTotal Scannable Devices% Coverage
      Desktop368,964253,75769%

       

       

      As you can see from the above example for the technology desktop the percentage is 69% and I want the expression to convert 69% to the number or value in another column as Coverage Value. Below is the expression which I'm using to get the % Coverage.

       

      % Coverage Expression : count(Total Scannable Devices)/count(Total Devices)

      Total Devices Expression: count(distinct columnname)

       

      Total Scannable Devices Expression: count(distinct if(Columnname='Scanned',Columnname))

       

      Regards,

      Bharath Vikas