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

    Pivot Table - Weekly difference with Colours

    Alex 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