Full the Data from only one table

[#1]

Hi All

          i have two Tables like:

Emp_code	Emp_name
101	abc
102	ghi

emp_code	emp_sal
104	10
105	20

if am loading into qlikview based oin EMP_code it will join

When i pull emp_code in list box it will show like

emp_code
101
102
104
105

i want retrieve the emp_code information from the first table

how we can do like that

can u suggests me

[alexandros17]

When you load first table, add a field:

Load

Emp_code,

Emp_Name,

'1' as TabNum

....

When you use the chart use the following formula:

If(TabNum=1, Emp_Code, Null())

Let me know ...

[sasikanth]

Hi

Making flag is one solutin and the other one is

add a new Copy of Emp_code of table 1

like

LOAD

emp_code,

emp_code as Tab1_emp_code,

Emp_name,

From........table1;

use that Teb1_emp_code to retieve only values from table 1

Hope it helps you