topic How can excel data have relationship in QlikView? in QlikView

How can excel data have relationship in QlikView?

Mon, 20 Feb 2012 10:22:05 GMT

Hi Friends,

Just curious how can excel data be added in Qlikview in such a way so that we have relationship between the data just as like relationship between tables. Basically, my question is , can we take excel as a substitute for a database while establishing relationship between data while dashboarding in QlikView.

Thanks All In Advance,

Regards,

tutan

Re: How can excel data have relationship in QlikView?

CELAMBARASAN — Mon, 20 Feb 2012 10:29:12 GMT

Hi,

Check with the attached image.which is in edit script dialog.

after click on the table file button.You will prompt to choose the excel, csv or anyother table format files.

Hope it helps

Celambarasan

How can excel data have relationship in QlikView?

jagan — Mon, 20 Feb 2012 11:41:54 GMT

Hi,

You can load Excel data into Qlikview. You can also load CSV, TSV, Excel, XML or any other database. The data should be in a valid format to read. Qlikview maintains the relationship between the datasources(Tables) based on the column names.

You can use the Table option in Qlikview Edit Script tab to import the data into Qlikview.

Hope this helps you.

Regards,

Jagan.

How can excel data have relationship in QlikView?

Mon, 20 Feb 2012 12:45:25 GMT

Thanks for your help. It works.