topic Drop a INNER JOIN in QlikView

Drop a INNER JOIN

Sun, 10 Apr 2011 10:47:53 GMT

Hey

I'm a new "Qlikviewer" and have following problem:

I have in a script a INNER JOIN between 2 MS Access Tables. The only linked field is "Idf" (=Identificationnumber)

In Table1 I have 3817 records, in table 2 I have a selection of 545 of the 3817 records wich not contains all the fields of table 1, but with other data.

In one Tabsheet I would like to see all 3817 records and in the other Tabsheet I only would like to see the selection linked to the fields of Table 1.

Can I Drop or Make the INNER JOIN when selecting a tabsheet and how can I achive this.

Many Thanks

Drop a INNER JOIN

deepakk — Sun, 10 Apr 2011 11:17:26 GMT

hi,

You can link the data in normal way at script where ldf will be your key field.

Once you linking is done at scrip level, what ever selection you make will effect both the tables.

For eg:

You have a pivot table with 3817 records (all data). you can select respective field values and the data in pivot table fill get filter out.

IF you want permanent filteration in report then you can add if clause or set analysis in your expression and can reduce the data.

If you can add a sample file we can show you how exactly it will work

AW:Drop a INNER JOIN

Sun, 10 Apr 2011 16:58:40 GMT

Hi fotoflip,

in addition to what deepak mentioned "You can link the data in normal way at script where ldf will be your key field." in the post above I would try the following:

Load your linking field in both tables A and B twice with two different names eg. ldf_A and ldf_B. And you still have the link with "ldf" from table A to table B. BTW: I would rename both to $ldf_ID to show they are since now (only) technical IDs to link the tables. In your charts and all other objects you can easily use ldf_A or ldf_B (or even $ldf_ID, if for some reasons necessary)

Regards, Roland