Equivalent of nested query

[andynext]

Hi, it's possible in Qlik Expression to make a selection based on other select ?

table_1 :

ID_command	ID_command_detail	PRODUCT
1	11	banana
1	12	apple
1	13	orange
2	21	banana
2	22	apple

I want to display in a table : SELECT *  from table_1 WJERE ID_command IN ( SELECT ID_command WHERE PRODUCT ="orange" )

If I use in the first column :  if(PRODUCT='orange', ID_command ) , the result is

ID_command	ID_command_detail	PRODUCT
1	13	orange

and not all product of ID_command = 1

Thanks

[sunny_talwar · Accepted solution]

May be you need this

Count({<ID_command = P({<PRODUCT = {'orange'}>})>} PRODUCT)

[andynext]

thank you very much, I just discovered P et E partition in SetAnalysis