Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prahlad_infy
Partner - Creator II
Partner - Creator II

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

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

1.PNG

Table 2

2.PNG

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

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

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.

Capture.PNG

View solution in original post

6 Replies
jwjackso
Specialist III
Specialist III

If you are filtering on entity, try

{<Entity=P(Order_Owner)>}

vishsaggi
Champion III
Champion III

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.

Capture.PNG

prahlad_infy
Partner - Creator II
Partner - Creator II
Author

THIS DIDNT WORK

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

prahlad_infy
Partner - Creator II
Partner - Creator II
Author

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 ;

prahlad_infy
Partner - Creator II
Partner - Creator II
Author

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

vishsaggi
Champion III
Champion III

Try on Purchase_Nbr like

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