topic Join Tow Field in QlikView

Join Tow Field

Wed, 06 Jul 2011 11:16:13 GMT

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)

Join Tow Field

Miguel_Angel_Baeyens — Wed, 06 Jul 2011 11:22:00 GMT

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

Join Tow Field

Wed, 06 Jul 2011 13:53:12 GMT

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