Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
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

Labels (1)
1 Reply
swuehl
Champion III
Champion III

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

Expression: Sumif