Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

Try this.

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


Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

3 Replies
Highlighted
Partner
Partner

Try

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

Highlighted
MVP & Luminary
MVP & Luminary

Try this.

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


Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

Highlighted
Contributor III
Contributor III

It worked. 🙂

Thank you very much.