4 Replies Latest reply: May 6, 2014 11:52 AM by Jason Ashinhurst RSS

    Summing a column then subtracting two dates

      Hi all,


      I am summing the totals for each measured day which is right when looking at one days worth of data in a column, but when I highlight two dates I want them to subtract each other and show in a column.


      For example, the first column ‘unassigned’ should read 4/29/14 – 4/28/14
      = (10,001).


      It is reading  (4/29/14) 309,719 + (4/28/2014) 299,718 = 609,437 which is


      Is this possible in Qlik? I attached a screen shot.


      Thank you,