topic Filtering data in a table. in QlikView

Filtering data in a table.

wgonzalez — Fri, 20 Jul 2012 13:57:15 GMT

Hi,

In a pivot table QV is showing all transactions in table Trans even if there is no corresponding record in table Emp. That's because Trans is a history table having all the transactions, while Emp has active employees only. I don't want QV to show transactions that does not have a corresponding associated record in the Emp table.

In SQL I can filter data in a table to get a selected group of records, I would do this:

select EmpID, Date, Transtype

from Emp, Trans

where Emp;.EmpID = Trans.EmpID

How would I do the same in QV?

Can I use a Set Modifier to use to perform that or should I do it in the script?

Thanks.

Re: Filtering data in a table.

Fri, 20 Jul 2012 14:05:10 GMT

you mean you've got two separete tables in QV? (check Ctrl+T)

Re: Filtering data in a table.

wgonzalez — Fri, 20 Jul 2012 14:22:36 GMT

Yes, one for employees and another for transactions. It has its purpose.

Re: Filtering data in a table.

MayilVahanan — Fri, 20 Jul 2012 14:31:35 GMT

HI,

You can use inner join both the table like,

Load * from TableA;

inner join(TableA)

Load * from TableB;

(or)

Simply concatenate both table

Load * from TableA;

Concantenate(TableA)

Load * from TableB;

(or)

Use can use exists functionality too,

Load *,Id as TransId from TableA;

Load *,Id as TransId from TableB where exists(Id,TransId);

Hope it helps

Re: Filtering data in a table.

wgonzalez — Fri, 20 Jul 2012 19:10:59 GMT

Thanks Mayil!