Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Partner
Partner

Equivalent of nested query

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

table_1 :

ID_commandID_command_detailPRODUCT
111banana
112apple
113orange
221banana
222apple

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_commandID_command_detailPRODUCT
113orange


and not all product of ID_command = 1


Thanks

Tags (2)
1 Solution

Accepted Solutions

Re: Equivalent of nested query

May be you need this

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

2 Replies

Re: Equivalent of nested query

May be you need this

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

Partner
Partner

Re: Equivalent of nested query

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