topic Re: loading data in QlikView

loading data

Anonymous — Fri, 19 Feb 2016 14:49:55 GMT

hii everyone

i have a excel sheet i am trying load the data from excel sheet for example assume i have excel sheet in sheet 1 i am having different tables in sheet 1 . i want generate the reports using those data . my questions is how split the table from excel and load into Qlikview . can u show with small example .. thanking u in advance....

Re: loading data

Anonymous — Fri, 19 Feb 2016 20:34:59 GMT

It is not very clear as to how the tables are separated in your excel. Are you saying you have more than one table in a single excel tab/sheet? By split the table do you mean how to load multiple tables in the single sheet into qlikview application? If that is so, one straight way to do would be to put each table in an individual excel sheet. This way qlikview can read it. Please provide the structure of your data and how you want them connected.

Re: loading data

Peter_Cammaert — Fri, 19 Feb 2016 21:04:25 GMT

Please post your Excel so that we can make a useful example document with an applicable script. Any other scripts we make will be wild guesses as to what exactly you are trying to do.

Re: loading data

settu_periasamy — Fri, 19 Feb 2016 22:54:55 GMT

Have a look here

How to pull data from multiple tables in a single excel sheet

Re: loading data

petter — Sun, 21 Feb 2016 22:37:09 GMT

You can name your three "tables" as named ranges in Excel. Then it is possible to select them as tables in the dropdown like you would select a normal Excel sheet in the file wizard.

I have enclosed a modified Excel file where I named the three tables and also a QVW-file that shows how the load script would look like.

You define a named range by selecting for instance A2:F7 like below and then type the name of the range in the Name Box like below "Payment1" and press enter:

The load script in the attached QVW looks like this:

LOAD type, 
     card, 
     remarks, 
     benfits, 
     remarks1, 
     [paytment type]
FROM

(ooxml, embedded labels, table is Payment1);

LOAD type, 
     card, 
     remarks, 
     benfits, 
     remarks1, 
     [paytment type]
FROM

(ooxml, embedded labels, table is Payment2);

LOAD [enroll type] AS type, 
     card, 
     remarks, 
     benfits, 
     remarks1, 
     [paytment type]
FROM

(ooxml, embedded labels, table is Enroll1);