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
      incorrect.

       

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

       

      Thank you,

      Jason