topic Re: what to put in Set expression to filter data from table 1st which is not present in table 2nd . Help please in QlikView

what to put in Set expression to filter data from table 1st which is not present in table 2nd . Help please

prahlad_infy — Wed, 25 Nov 2020 16:16:04 GMT

Hello Sirs ,

what to put in Set expression to filter data from table 1st which is not present in table 2nd .

In attached data set i want to filter out those Entity which are not present in Status table

Table 1

Table 2

I want to filter out highlighted records of table 1 in separate column , because those entity are not present
in Order_owner column of table 2 , using set expression

Thank You

Re: what to put in Set expression to filter data from table 1st which is not present in table 2nd . Help please

jwjackso — Mon, 18 Jun 2018 18:42:26 GMT

If you are filtering on entity, try

{<Entity=P(Order_Owner)>}

Re: what to put in Set expression to filter data from table 1st which is not present in table 2nd . Help please

vishsaggi — Mon, 18 Jun 2018 18:59:08 GMT

try like in your calculated dimensions.

= Aggr(IF(Entity <> Order_Owner, Entity), Entity)

Like use straight table with

Dim: = Aggr(IF(Entity <> Order_Owner, Entity), Entity)

add other dimensions.

Expr: 1

Then in presentation tab just hide the expression 1.

Re: what to put in Set expression to filter data from table 1st which is not present in table 2nd . Help please

prahlad_infy — Tue, 19 Jun 2018 06:59:08 GMT

THIS DIDNT WORK

Count({<Entity=P(Order_Owner)>}Entity)

Re: what to put in Set expression to filter data from table 1st which is not present in table 2nd . Help please

prahlad_infy — Tue, 19 Jun 2018 09:28:19 GMT

Thank you Nagaraju ,

What if i am droping field from 2nd table

LOAD Order_Owner,

Nbr,

Status,

AutoNumberHash256(Order_Owner&'|'&Nbr) as key

FROM

Data.xlsx

(ooxml, embedded labels, table is Status);

DROP Field Order_Owner ;

Re: what to put in Set expression to filter data from table 1st which is not present in table 2nd . Help please

prahlad_infy — Tue, 19 Jun 2018 09:31:32 GMT

Can you suggest me any other alternative to Aggr(IF(Entity <> Order_Owner, Entity), Entity)

Re: what to put in Set expression to filter data from table 1st which is not present in table 2nd . Help please

vishsaggi — Tue, 19 Jun 2018 13:29:36 GMT

Try on Purchase_Nbr like

= Aggr(IF(Purchase_Nbr <> Nbr, Entity), Entity)