Pls clarify my doubt on table links

[#1]

Dear all,

               I have two tables namely table1 and table2 which has a unique field DOCID. Table1 has a status field, this field is my input parameter. For example i want to see finished records from two tables how should i link table 1 and table 2

TABLE 1
FIELD1	DOCID	FIELD2	FIELD3	STATUS
AAAAA	A123	BBB	CCC	Finished
bbbbbbb	A124	BBB	CCC	Pending
TABLE 2
TFIELD1	DOCID	TFIELD2	TFIELD3
sdfsdf	A123	dsfsdf	sdfds
sdfsdf	A124	dsfsdf	sdfds

Please clarify me

Regards

Vignesh Babu.CV

[jagan]

Hi Vignesh,

In Qlikview tables are joined based on the common column name, I hope you are aware of that.

When you load two tables the tables are joined by DOCID, and provide Status as List box, if the user selects Finished then only Finished records are displayed.

If you want to show only Finished records without selection try like this

Straight

Dimensions:

FIELD1

Expression: Only({<STATUS={'Finished'}>} DOCID)

Regards,

Jagan.

[sujeetsingh]

Just use normal linking of the table and use expressions to filter the data