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

Join Tow Field

Good morning,

I´m trying to select a Field call month that i have in two table, the firts one is an excel table (BUDGET)  I make a Croos table (see attached file) the second one (SALES) is in my ERP (Oracle DB) in Both the field is Called T$PERI$O, but when it is showing appear duplicated (see attached File).

I want to select only one month to show me the Budget and Sales for the same Month.

I´ll appreciate your help to solve this issue.

(Please see attache file, where I´m mtrying to explain this case)

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi,

It seems it's because values from excel are interpreted as strings and from Oracle as numbers or viceversa. Take a look at this post that seems very similiar to your issue.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

View solution in original post

2 Replies
Miguel_Angel_Baeyens

Hi,

It seems it's because values from excel are interpreted as strings and from Oracle as numbers or viceversa. Take a look at this post that seems very similiar to your issue.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable
Author

Thanks a lot Miguel, It´s working fine now.....