topic Re: Loading excel data to my existing dashboard in QlikView

Loading excel data to my existing dashboard

Thu, 18 Dec 2014 05:38:19 GMT

Hi All,

I am trying to load excel data to my existing dashboard which has data from mysql. Now, I want to combine the fields from Excel and some fields from Mysql and create few charts/tables, etc.

I have successfully loaded the excel data into my dashboard. I can view the fields and can create list boxes. But, the excel table is not linked to the Mysql tables as primary key is not set. I have checked in table viewer the excel table stands alone. How can I create the link between the excel and mysql tables?

Please share your valuable suggestions.

Thanks,

Muru

Re: Loading excel data to my existing dashboard

amit_saini — Thu, 18 Dec 2014 05:44:45 GMT

Hi Murugesh,

For creating link between these two table source you should have a common key , otherwise no use of calling these tables.

Thanks,

Re: Loading excel data to my existing dashboard

Thu, 18 Dec 2014 05:47:22 GMT

Yes Amit, you are right. I would like to know how I can create the common key between these sources. Please advice.

Thanks,

Muru

Re: Loading excel data to my existing dashboard

amit_saini — Thu, 18 Dec 2014 05:52:23 GMT

Hi,

For example I'm having two tables say table1 and table2

Table1: (Suppose this table you are loading as Excel sheet)

Name

Marks

Table 2: (This table from some other source )

Students

Grade

In above example suppose Name (Table1) and Students(Table2) is having same values say A,B,C,D etc .

So for making link between to tables you can rename either Name as Students or the other way.

This will automatically create link between these two tables and you will get relevant data.

Thanks,
AS

Re: Loading excel data to my existing dashboard

amit_saini — Thu, 18 Dec 2014 06:01:29 GMT

Also please go through these links, will help u how you can create joins between 2 or more tables:

QlikView Joins

Some Qlikview Joins best documents

Thanks,
AS

Re: Loading excel data to my existing dashboard

Thu, 18 Dec 2014 06:01:29 GMT

It works now. Thank you so much, Amit!

Can you share me your email id? I just want to be in touch with you.

Thanks again!

Regards,

Muru

Re: Loading excel data to my existing dashboard

amit_saini — Thu, 18 Dec 2014 06:04:38 GMT

My pleasure

No problem I will send u friend request.

Thanks,
AS