Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am loading two tables into my QlikView Report.
Table 1 is a table of Goods Received positions. Each position has the identity code of the person who performed the goods receipt.
Table 2 is a table of purchase order positions that auto-joins to the Goods received table on purchase order and position.
Again each position has the code of the person who raised the position as a purchase order.
I want to be able to limit the displayed data in a Chart/Straight Table to just the rows where Table1.PersonCode = Table2.PersonCode
by clicking a button or making a listbox selection but I can't see how to do it without joining the two tables into one and loading the joined table with an 'IF' condition on the load to build an indicator field for selection - which seems poor.
Any ideas?
Without seeing sample data, it is a bit difficult. However, I will give a try:
Maybe create two other tables:
[Person Universe]:
LOAD
PersonCode,
'Table1' As Source
Resident [Table 1];
LOAD
PersonCode,
'Table2' As Source
Resident [Table 2];
NoConcatenate
LOAD
If(PersonCode = Previous(PersonCode) and Source <> Previous(Source), 'Exist in ' & Source & '|' & Previous(Source)) As Flag,
PersonCode
Resident [Person Universe]
Order By PersonCode, Source;
Drop Table [Person Universe];
Hopefully, Flag field can indicate those persons who are in both tables.
Without seeing sample data, it is a bit difficult. However, I will give a try:
Maybe create two other tables:
[Person Universe]:
LOAD
PersonCode,
'Table1' As Source
Resident [Table 1];
LOAD
PersonCode,
'Table2' As Source
Resident [Table 2];
NoConcatenate
LOAD
If(PersonCode = Previous(PersonCode) and Source <> Previous(Source), 'Exist in ' & Source & '|' & Previous(Source)) As Flag,
PersonCode
Resident [Person Universe]
Order By PersonCode, Source;
Drop Table [Person Universe];
Hopefully, Flag field can indicate those persons who are in both tables.
May be some data sample would help us to solve your issue. please let us know if Sinan's solution solved your purpose.
Pretty much what I was trying to avoid but had to go with it as I can't figure an alternative way.