1 Reply Latest reply: Jan 25, 2016 7:35 AM by Stefan Wühl RSS

    Expression: Sumif - From Unqualified Table

      Hi All - New to Qlikview - (Might I ask for you to be gentle with me!)

       

      I have two tables: Tab_1 and Tab_2

       

      Tab_1.Capture PointValue

      Sales

      10

      Costs5
      Other2

       

      Tab_2 is:

      1) unlinked/Qualified (Very Important) - contents of

      2) was created as an inline table

       

      Tab_2.Capture Point
      Costs
      Other

       

      I have inserted a straight table in qv - the dimensions of which are those from Tab_2.

      I would like to sum from Tab_1 where values in Tab_1.Capture Point = values in the straight table (Tab_2.Capture Point)

      I would prefer to use the expression builder as a means of achieving this - basically, i need a sumif(tab_1.Capture Point,tab_2.capture point,tab_1.value)

       

      Please advise

       

      Many thanks

       

      S