2 Replies Latest reply: Jul 17, 2017 12:04 AM by Vinayak Bhatt RSS

    Unable to color conditional formatting

    Vinayak Bhatt

      Hi,

       

      I am a novice in Qlik Sense.I have created a pivot table similar to the table below.

      ABCD
      new york12.6%50
      London14.5%70
      Paris15%80
      Total1360

       

      Here I have created the total row through the slider option in general tab.

       

      now I have to condition format each column for eg:
      if  value in B is >total's 90% then green if below totals 10% then red.
      Hope my explaination helps I am not able to find solution in any of the qlik community discussions.

      I ahve a deadline to meet if anyone could Please help me on this.

       

       

       

      Regards

      Vinayak