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

    Percentage and Values in Pivot Table

    Arjun Arjun

      Hi,

       

      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.


      Regards

      Arjun.