topic Re: Full the Data from only one table in QlikView

Full the Data from only one table

Wed, 09 Jul 2014 08:59:14 GMT

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

i want retrieve the emp_code information from the first table

how we can do like that

can u suggests me

alexandros17 — Wed, 09 Jul 2014 09:08:09 GMT

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 — Wed, 09 Jul 2014 09:17:10 GMT

Making flag is one solutin and the other one is

add a new Copy of Emp_code of table 1

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