1 Reply Latest reply: Oct 4, 2018 2:22 AM by abhishek singh RSS

    Qliksense Pivot Table Color formatting

    abhishek singh

      i have a  pivot table and in dimesion i am showing country, in columns i an showing months, and in the measure sum of sales,

      my requirement is like if previous month sales is more compared to this month the color should be red else green

      eg:

      Header 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8Header 9
      month 1month 2month 3month 4month 5month 6month 7month 8
      India2123202526282622
      canada
      322146566675667

       

      so for this i wrote an expression like

      if(Before(sum(Sales),1)<sum(Sales),'Green','Red'), it is working for most of the cases but failing many places.

       

      any solution ?