Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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
Highlighted
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
Specialist III
Specialist 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