2 Replies Latest reply: Oct 14, 2016 12:38 AM by Torsten Kossmann RSS

    Query of different columns and output total

    Torsten Kossmann

      I apologize for the question, but I'm just starting to work in Qlik Sense and still hang in a lot of places, but what I think is normal at the beginning - there are endless possibilities.

       

      A sum of column B with restriction in column A I get over yes

       

      Sum ({$ <AUFHDRDB.BEL_ART = {R}>} AUFHDRDB.SUM_N_EUR)

       

      If I now however the restriction must expand, then I come no further. Say I would like to receive the Sumnme of AUFHDRDB.SUM_N_EUR if AUFHDRDB.BEL_ART = A and AUFHDRDB.STATUS = O or G or T

       

      I have it with you

       

      Sum ({$ <[UPDATE.BEL_ART] = {A} and ([UPDATE.STATUS] = {O} or [UPDATE.STATUS] = {G} or [UPDATE.STATUS] = {T})>} PICK UP. SUM_N_EUR)

       

      Sum ({$ <[UPDATE.BEL_ART] = "A" and ([UPDATE.STATUS] = "O"} or [UPDATE.STATUS] = "G"} or [UPDATE.STATUS] = "T"}) } AUFHDRDB.SUM_N_EUR)

       

      and

       

      Sum ({$ <[UPDATE.BEL_ART] = 'A' and ([UPDATE.STATUS] = 'O'} or [UPDATE.STATUS] = 'G'} or [UPDATE.STATUS] = 'T'}) } AUFHDRDB.SUM_N_EUR)

       

      Tried, but always get an error displayed. My question is where this is. Would be glad if someone could show me my mistake. Thank you!