4 Replies Latest reply: Dec 4, 2017 4:18 AM by Tom Müller RSS

    Use of Sum-Expression in simple Table

    Tom Müller

      Hi all together,

       

      I got a little issue in trying to sum up values. My original excel sheet gives me different projects and payments, it may be that there are several payments to a project, so it appears repeatedly in my excel sheet.

       

      What I would like to do is creat a simple Table in QLIK, where I can show the Payments summed up and the costs, that come from another table. My problem right now is, that when I use the expression Sum(Payment), a invalid dimension is criticized.

       

      My table looks like this when I just use the Payments as field (it's called "Erlös").

       

      Erlös.JPG

      As it can be seen, QLIK lists up all the Payments from the original source. I would like to show just one column, so that it's like

       

      Projektstart

      ErlösKosten
      -391363,01-15634,65

       

      May it work with this form of graph or will I have to choose another one?

       

      Thanks for the replies.

       

      Greetings

      Tom Müller