Link tables

Mon, 27 Apr 2015 11:46:56 GMT

I have two tables I wish to link on a field that is common but not by name.

The first is a list of orders with a field marked roa-code (which is the Sales rep code). I then have a table with rep-code (which is the Sales rep code) and rep-desc.

Field roa-code and rep-code have the same data within them and I would like to be able to call the rep-desc so when reporting I get the rep-code and rep-desc together.

i.e.

TABLE 1 roa-code sales-value etc

TABLE 2 rep-code rep-desc

output I want is

roa-code + rep-desc sales-value

Thanks for any help

Re: Link tables

Anonymous — Mon, 27 Apr 2015 11:51:00 GMT

alias the column name with same name for join .

topic Link tables in QlikView

Link tables

Re: Link tables