Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Join Tow Field

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

2 Replies

Join Tow Field

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

Join Tow Field

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

Community Browser