Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
S
Please try to avoid multiple postings with the same request, it makes it hard to follow a discussion.