Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can excel data have relationship in QlikView?

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

3 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

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

jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

Thanks for your help. It works.