Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey everyone,
I am relatively new to Qlikview and have a question:
In my table structure I have two tables that are connected to each other by a key (possible n:m - connection). In both tables there is a column that could also be connected but because of the complicated table structure (in real, not in the example attached) this is not possible.
What I now want is to sum values of both tables having the unconnected column as a dimension which means I have to pick the ConnectColumn1 (table 1) to sum up Value1 (of table 1). Now I want to sum up value 2 (where ConnectColumn2=ConnectColumn1 in table 2). Can you tell me how to do this? I am sure there is a way with Set-Analysis but I dont really get it.
I attach a very simple example.
Thanks a lot, guys!
Regards,
Michael
Add and try this script:
table1:
load
KEY,
ShouldConnect2 as ShouldConnect,
Value2
Resident Value2;
table2:
load
KEY,
ShouldConnect1 as ShouldConnect,
Value1
Resident Value1;
DROP table Value1;
DROP table Value2;
Yes, this would work, but as I need to implement the described aaproach in antoher application, i rather would like to follow my "plan".