Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Jesh19
Contributor II

join not working between excel and sql table

Hi All,


I'm having the below 2 tables, Dimsales coming from Excel and Facts_L1 coming from DB.

The association between the 2 tables is maintained using Sales_RepKey.


But, somehow the association doesn't seems to be proper. If I'm selecting some value on Excel field, it's not showing the proper associated value from DB.

I want both the fileds to be associated properly.


Join Error.png

I want the association in such a way that if i select Australia from Cluster(DB), it should associate to Australia in Dimsales_Cluster(Excel).



The script used is as follows:


DimSales:

LOAD    

     UPPER(DimSales_Date &'-'& DimSales_Person_Email) as Sales_RepKey,

     DimSales_Date,

     DimSales_Cluster,

     DimSales_Region,

     DimSales_Country,

     DimSales_Branch

FROM

(qvd);

Left Join (DimSales)

Facts_L1:

LOAD

Date,

Cluster,

Region,

Country,

Branch, 

UPPER(MonthName(Date)&'-'& Sales_Person_Email) as Sales_RepKey 

FROM

(qvd)

where Date >= '01/01/2015';

Could someone please do the needful.

Thanking in Advance.

Regards,

Jesh

4 Replies
kakani87
Valued Contributor

Re: join not working between excel and sql table

can you share some  sample data

mayankraoka
Valued Contributor

Re: join not working between excel and sql table

Can you check whether thw value /format in your joining key ia same or not ?

On Sun, Jun 3, 2018, 11:56 PM Jeshwanth Boragani <qcwebmaster@qlikview.com>

Jesh19
Contributor II

Re: join not working between excel and sql table

Hi Mayank,

The value/format in my joining key is same.

Thanks & Regards,

Jesh

mayankraoka
Valued Contributor

Re: join not working between excel and sql table

ok,Can you please share qvw so that I can look into it?

Regards,

Mayank