Expression: Sumif - From Unqualified Table

Mon, 25 Jan 2016 11:41:42 GMT

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 Point	Value
Sales	10
Costs	5
Other	2

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

Re: Expression: Sumif - From Unqualified Table

swuehl — Mon, 25 Jan 2016 12:35:06 GMT

Please try to avoid multiple postings with the same request, it makes it hard to follow a discussion.

Expression: Sumif

topic Re: Expression: Sumif - From Unqualified Table in QlikView

Expression: Sumif - From Unqualified Table

Re: Expression: Sumif - From Unqualified Table