Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahmoud
Partner
Partner

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

View solution in original post

Mahmoud
Partner
Partner
Author

it works, Thank youuu 🙂