6 Replies Latest reply: Jul 19, 2018 6:54 AM by Alexander James Tomlins RSS

    Pivot Table - Weekly difference with Colours

    Alexander James Tomlins

      Hi All,


      I'm trying to do something i can do in excel but on a pivot table in QlikSense.

       

      What i would like to do is to look at revenue actual financial difference week on week on a table. So rows would be product, Column YearWeek and revenue difference between that week and the previous week. Then i would like to colour the difference in a heatmap style? Would i need to do this in the script or can i use a formula in the UI?

       

      Rev Heatmap example.PNG