Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

sassoumani
New Contributor

IS it possible to use set analysys for Exclude values fiedls ?

Hi Every body , 

I need your help please : 

I have a data model with a STOCK and SALES table :`

 

STOCK : 

ID_ITEMStk_Value
10100
20200
30300
40400

 

SALES

ID_ITEMAmount
1050$ 
30100$

 

I need to return all ITEM in stock with no sale .

what is the simpliest way to do that ? using set analisys ?

 

2 Replies
Partner
Partner

Re: IS it possible to use set analysys for Exclude values fiedls ?

hi 

no need for set analysis 

you can use this straight forward expression

if(sum(Stk_Value)>0 and sum(Amount)=0,sum(Stk_Value))

Highlighted
mdmukramali
Valued Contributor III

Re: IS it possible to use set analysys for Exclude values fiedls ?

Hi,

You can use the below expression :

=Only({<ID_ITEM= E({<Amount={"*"}>}) >}Stk_Value)

find the attached sample file

Thanks,

Mohammed Mukram