Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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)

View solution in original post

2 Replies

Re: Equivalent of nested query

May be you need this

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

View solution in original post

Partner
Partner

Re: Equivalent of nested query

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