2 Replies Latest reply: Aug 4, 2016 4:13 PM by Vishwarath Nagaraju RSS

    Conditional color for totals in Pivot Table

    Fabian Heidenstecker

      Hello Qlik Comnunity,

       

      i have a question how to conditionally set the color of the totals in a Pivot table. I want to highlight the columns depending if the value is bigger or smaller than last years value.

       

      I was able to access the Column using columnno()=0, and checking the year. But now i am stuck comparing the values for the years.

      community.png

      I attached a sample file....

       

      Can anybody help?

      Regards from Germany,
      Fabian