topic How to create report from excel file in QlikView

How to create report from excel file

Anonymous — Tue, 25 May 2010 20:36:19 GMT

I am a beginner with QlickView , just started out trying to create a report from an excel file >

Could anyone please assit me in doing this or show me the link or any documentation which has the procedure for doing this from the scratc?

Thank you

Ramya

How to create report from excel file

fernandotoledo — Tue, 25 May 2010 20:56:34 GMT

Hi Ramya,

When you install QlikView, make sure you choose the Complete Instalation.

In your "c:\Program Files\QlikView" folder you´ll find the Documentation folder wich contains a complete tutorial.

It comes with data files and a little Manual in PDF.

This should be your first steps! Welcome to the Jungle!

Fernando

How to create report from excel file

Anonymous — Tue, 25 May 2010 21:09:45 GMT

Thank you Fernando ,

I using the trail version , i have got the documentation with pdf doc where the procedure for DB connection is given , i am looking for one where we create a sample report based on data in an Excel file ..

Could you please assit me with this...

Thank you

How to create report from excel file

boorgura — Tue, 25 May 2010 21:26:46 GMT

Ramya,

you can use the wizard to load data from excel.

You have a button - "TABLE FILES" in the bottom half of the script editor.

Click that --> pick your excel file --> then select your sheet name from the drop_down.

Click finish.

that will populate the script to load all the available fields from that sheet.

You can eliminate the ones you dont want to load.

Feel free to ask any questions.

How to create report from excel file

boorgura — Tue, 25 May 2010 21:29:30 GMT

For your convenience, a sample script:

LOAD ID,
NAME
FROM (biff, embedded labels, table is [Sheet1$]);

How to create report from excel file

Anonymous — Tue, 25 May 2010 21:29:53 GMT

Exactly i am struck at the same position , my main page is blank now , i created the script and saved it and clicked on reload , it ran some scripts and main page is blank now,

Please bare with my basic question i may sound like a dumb initially but trying to catch up with this new stuff...

How to create report from excel file

boorgura — Tue, 25 May 2010 21:36:07 GMT

Alright once reloaded, you can right click on your main page (or UI) and then add components like list boxes or chart.

Or simply right click --> Select fields --> Add All.

That will bring all the fields as list boxes onto the UI.

How to create report from excel file

Anonymous — Tue, 25 May 2010 22:39:54 GMT

I have created a simple table report which is fine , it reflects with filters , as i select from the list box, but i have added a barchart in the same page , but that does not reflect any data ?

Where do i have set this?

Is it like one page can have only one item ?

And also could you please let me know how do we set x and y axis for a bar chart ??

I have a date column which has to be on X axia, and run_minutes on y axis..

How to create report from excel file

boorgura — Wed, 26 May 2010 04:15:26 GMT

Hey Ramya,

you can put your date in the dimensions and then the run_minutes as an expression.

You can have multiple objects on the same page.