14 Replies Latest reply: Jul 18, 2017 7:26 AM by Sunny Talwar RSS

    Regarding color by expression by comparing rows to overall

    Vinayak Bhatt

      Hi Community,

       

      I am a novice stuck in an issue for past week.


      I have a pivot table where I am created the total by using qlik feature of showing overall by going to general tab.


      But I have to compare the values with this  overall

       

      eg

       

      if (overall>count({$<[City]={'New York'}>} City)/Count(No of Employees),green(),white)

       

      Especially requesting celambarasan sir as he has helped in a post similar to it but I am not able to figure it out.


      Eagerly awaiting your response.

       

      Regards,
      Vinayak