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: 
Mahmoud
Partner - Contributor III
Partner - Contributor III

restriction between 2 set analysis

Hello,

I want to show only the rows where  "Ventes" = 0 

Expression CA net:  Sum({<Mouvement_ID={'AC'},Date={">=$(vDateP1D)<=$(vDateP1F)"}, Typologie ={"NEW"}>} Total_Net_HT)

Expression Ventes:  Sum({<Mouvement_ID={"VC"}>} Total_Net_HT)

Img1.png

 

Thank you

1 Solution

Accepted Solutions
sunny_talwar

May be this

Expression CA net

If(Sum({<Mouvement_ID={"VC"}>} Total_Net_HT) = 0,
Sum({<Mouvement_ID={'AC'},Date={">=$(vDateP1D)<=$(vDateP1F)"}, Typologie ={"NEW"}>} Total_Net_HT)
)

Expression Ventes

If(Sum({<Mouvement_ID={"VC"}>} Total_Net_HT) = 0,
Sum({<Mouvement_ID={"VC"}>} Total_Net_HT)
)

View solution in original post

2 Replies
sunny_talwar

May be this

Expression CA net

If(Sum({<Mouvement_ID={"VC"}>} Total_Net_HT) = 0,
Sum({<Mouvement_ID={'AC'},Date={">=$(vDateP1D)<=$(vDateP1F)"}, Typologie ={"NEW"}>} Total_Net_HT)
)

Expression Ventes

If(Sum({<Mouvement_ID={"VC"}>} Total_Net_HT) = 0,
Sum({<Mouvement_ID={"VC"}>} Total_Net_HT)
)
Mahmoud
Partner - Contributor III
Partner - Contributor III
Author

it works, Thank youuu 🙂