How to create report from excel file

[Anonymous]

Hi

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

[fernandotoledo]

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

[Anonymous]

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

[boorgura]

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.

[boorgura]

For your convenience, a sample script:

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

[Anonymous]

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...

[boorgura]

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.

[Anonymous]

Hi

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..

[boorgura]

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.