topic Re: Pls clarify my doubt on table links in QlikView

Pls clarify my doubt on table links

Tue, 02 Sep 2014 05:42:32 GMT

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

Re: Pls clarify my doubt on table links

jagan — Tue, 02 Sep 2014 05:49:34 GMT

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.

Re: Pls clarify my doubt on table links

sujeetsingh — Tue, 02 Sep 2014 09:01:15 GMT

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