Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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)

Labels (1)
1 Solution

Accepted Solutions
Miguel_Angel_Baeyens
Support
Support

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
Support
Support

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.....