topic Different tabs,different data sources in QlikView

Different tabs,different data sources

Thu, 15 Jan 2015 09:46:17 GMT

Hi,

I am new to QlikView.I have 3-4 excel files(some have same fields as well). I want each tab in qlikview using each of these excel file as data source. So I would like to know:

1.How to I import multiple excel files into QlikView and.

2. How do I make each tab having different data sources.

Thanks in Advance.

Re: Different tabs,different data sources

ashfaq_haseeb — Thu, 15 Jan 2015 09:53:03 GMT

HI,

I can think of two different approaches.

If there is no physical relationship between thees files then loading all 4 tables without linking each other will surve the purpose.

If there is any logical connection I would suggest you to go with alternate states.

http://community.qlik.com/message/639498#639498

Hope it helps

Regards

ASHFAQ

Re: Different tabs,different data sources

Thu, 15 Jan 2015 09:57:41 GMT

Hello Swetha,

Make sure your data are clean such that your if you have common fields in the 4 different table they should have same name and if you are using lowercase in naming it should be universal for all the four tables.

If you are pulling data from Excel its better you do the cleansing in your table but if its SQL pull and save to QVD or back to excel so you can manipulate.

Hope this help

Re: Different tabs,different data sources

Thu, 15 Jan 2015 09:57:49 GMT

I need similar graphs in both the tabs and I have copied the whole sheet.Now I would want the second sheet have a different source.How do I change data source for the second tab?

Re: Different tabs,different data sources

alexandros17 — Thu, 15 Jan 2015 09:57:50 GMT

If Excel files have the same structure then you can use a routine to load them otherway I suggest to load files one by one (you can use the button "Table File" in the script section)

The script to load all files is:

let path_Pallet = '..\..\qlik\MyFiles_*.xlsx';

for each File in filelist (path_Pallet)
myTab:
LOAD
field1,

field2,

....

FROM $(File) (ooxml, embedded labels, table is Foglio1);
next File

Probably files have common fields, in this case there will be relations among the source files, if this is right then in each tab add a chart (straight table for example), then select the table you want to read and add fields.

let me know

Re: Different tabs,different data sources

ashfaq_haseeb — Thu, 15 Jan 2015 10:00:45 GMT

HI,

If you have same structure then I would prefer to concatenate this with Flags.

So that you can use flag to change source.

Regards

ASHFAQ

Re: Different tabs,different data sources

Thu, 15 Jan 2015 10:01:14 GMT

How do I change datasource for a tab.

Re: Different tabs,different data sources

alexandros17 — Thu, 15 Jan 2015 10:04:28 GMT

When you load define a name for the table:

MyTable:

load * from ...

then in your table, on the left and bottom there is a list box: "Select fields from table", there you can select your table

Re: Different tabs,different data sources

Thu, 15 Jan 2015 10:20:31 GMT

Hello Swetha,

Include a new connection string to the new table.

Rgds

Re: Different tabs,different data sources

Fri, 16 Jan 2015 10:08:15 GMT

Thanks Guys I found the way. I was making changes in the script as u mentioned. But I was not able to see those tables in Field values. The only mistake I was doing was, I didnt click on "RELOAD". After changing the script, pressing "Reload" will solve the problem.

Re: Different tabs,different data sources

Fri, 13 Feb 2015 19:04:03 GMT

Hi Alessandro,

I'm trying to do this as well but I'm not totally following your instructions. When I try to specify the files I want to load for each table, the dimensions of same name are still being combined. For example, if I have a dimension named "pet" in file 1 and a dimension named "pet" in file 2, I want to only see the data values under "pet" from file 1 on one tab and the data values under "pet" from file 2 on the other tab. I've tried to tell the charts on each tab to reference only the relevant table from the script (i.e. Sheet3 and Sheet4) but they're still combining. Here's the script I'm using--can you help troubleshoot?

Sheet3:
LOAD Pet
FROM

(ooxml, embedded labels);

Sheet4:
LOAD Pet
FROM

(ooxml, embedded labels);