Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sassoumani
Contributor II
Contributor II

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 ?

 

Labels (4)
1 Solution

Accepted Solutions
mdmukramali
Specialist III
Specialist III

Hi,

You can use the below expression :

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

find the attached sample file

Thanks,

Mohammed Mukram

 

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

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

mdmukramali
Specialist III
Specialist III

Hi,

You can use the below expression :

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

find the attached sample file

Thanks,

Mohammed Mukram