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: 
benoitgochel
Contributor III
Contributor III

Set Analysis with multiple conditions

Hi All,

I have a set analysis to make in order to exclude fields in a table.

I want to keep only the lines from the subProjectGroup "P3" with a status "In Process" or "En cours".

Here is my formula :

Num(Sum({<[Proj.SousGroupeProjet]={"P3"}>}{<[Proj.ProjectStatus]={"En cours","In Process"}>}[#Hours.QTY]), '$(vNumFormat)')

When I put

Num(Sum({<[Proj.SousGroupeProjet]={"P3"}>}[#Hours.QTY]), '$(vNumFormat)')

it works fine... same for

Num(Sum({<[Proj.ProjectStatus]={"En cours","In Process"}>}[#Hours.QTY]), '$(vNumFormat)')


But when I put both conditions, only the 'Proj.ProjectStatus' one is taken.

What can I do to solve this?

Thank you in advance.

Best regards

1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Try this.

Num(Sum({<[Proj.SousGroupeProjet]={"P3"},[Proj.ProjectStatus]={"En cours","In Process"}>}[#Hours.QTY]), '$(vNumFormat)')


Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

3 Replies
shraddha_g
Partner - Master III
Partner - Master III

Try

Num(Sum({<[Proj.SousGroupeProjet]={"P3"}>} * {<[Proj.ProjectStatus]={"En cours","In Process"}>}[#Hours.QTY]), '$(vNumFormat)')

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Try this.

Num(Sum({<[Proj.SousGroupeProjet]={"P3"},[Proj.ProjectStatus]={"En cours","In Process"}>}[#Hours.QTY]), '$(vNumFormat)')


Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
benoitgochel
Contributor III
Contributor III
Author

It worked. 🙂

Thank you very much.