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




      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.