topic Re: Equivalent of nested query in QlikView

Equivalent of nested query

andynext — Sat, 18 Nov 2017 17:57:13 GMT

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

table_1 :

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 — Sat, 18 Nov 2017 22:57:53 GMT

May be you need this

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

andynext — Sun, 19 Nov 2017 09:01:57 GMT

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