topic Linking 2 tables in QlikView

Linking 2 tables

Fri, 28 May 2010 16:53:05 GMT

Hello,

I have an excel file with 14 sheets which have tables with the same format. Let's say they all have tables

with fields A, B and C. I could read the values these fields and put each of them in one table (Lets say tables A, B and C).

Then I made a table that holds the names of the 14 sheets (Let's call it table D).

Now I need to associate D with A, B and C, so that for example when I choose the title of sheet one from table D, all the

entries in A, B and C that were read from the 1st sheet turn white and everything else turns gray.

Can you tell me how I can associate these tables?

Thank you very much,

Naeemeh

Linking 2 tables

Fri, 28 May 2010 17:37:17 GMT

I presume your going to lead each sheet separately into QV and then store that into one QVD? if so instead of making a separate table in excel with the sheet names, why not add the sheet name within the load in QV.

LOAD
a,
b,
c,
'Sheet1' as d

FROM
[Excel.XLs]
(biff, embedded labels, table is Sheet1$);

Then you can make a list box for d so you can select the data you require. Hope this helps.

Shaun

Linking 2 tables

Fri, 28 May 2010 18:58:14 GMT

That was easy !!

Thank you so much 🙂

Linking 2 tables

Fri, 28 May 2010 19:19:22 GMT

Just realized a little problem.

When I make a Table Box with the loaded data, I get an empty row for each sheet.

Do you know why?

Thanks,

Naeemeh

Linking 2 tables

Fri, 28 May 2010 20:12:25 GMT

There are no empty data when I make a List Box for each field and I don't have an empty entry

in the excel sheet. I only the empty rows when I make a Table Box.