3 Replies Latest reply: Jul 8, 2016 1:37 AM by Arjun Arjun RSS

    Percentage and Values in Pivot Table

    Arjun Arjun



      Can any one please help me, how to create a column with % as shown in the attachment.


      I'm not able to create % of Compliant and % of Non-Complaint

      Logic for Compliant and Non-Compliant

      % of Compliant = Compliant total / (Compliant total + Non-Compliant total)

      % of Non-Compliant = Non-Compliant total / (Compliant total + Non-Compliant total).


      When I create a new expression, it applies to all other measures and dimensions.


      I looking to replicate the same thing in qlik sense.


      Thanks in Advance.