Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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

1 Reply
MVP
MVP

Re: Expression: Sumif - From Unqualified Table

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

Expression: Sumif

Community Browser