Qlik Community

Qlik Sense App Development

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

benoitgochel
New 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

Tags (2)
1 Solution

Accepted Solutions

Re: Set Analysis with multiple conditions

Try this.

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


Regards,

Kaushik Solanki

3 Replies
shraddha_g
Honored Contributor III

Re: Set Analysis with multiple conditions

Try

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

Re: Set Analysis with multiple conditions

Try this.

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


Regards,

Kaushik Solanki

benoitgochel
New Contributor III

Re: Set Analysis with multiple conditions

It worked. :-)

Thank you very much.

Community Browser