topic Set Analysis with three measures in QlikView

Set Analysis with three measures

Prav — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

Is it possible to write below condition in set analysis?

If(Country='A' and Company='A', sum(Net Sales),

If (Country='B' and Company='B', sum(Gross Sales),

sum(Total Sales)))

Thanks.

Re: Set Analysis with three measures

Kashyap_R — Fri, 29 Nov 2019 15:02:04 GMT

try this

Sum(If(Country='A' and Company='A', (Net Sales),If (Country='B' and Company='B', (Gross Sales),(Total Sales))))

Thanks

Re: Set Analysis with three measures

Prav — Fri, 29 Nov 2019 15:06:57 GMT

Hi thanks for your reply. That is not the solution I want. I want the condition in set analysis.

Re: Set Analysis with three measures

sunny_talwar — Fri, 29 Nov 2019 16:26:11 GMT

You can try this

RangeSum( Sum({<Country = {'A'}, Company = {'A'}>} [Net Sales]), Sum({<Country = {'B'}, Company = {'B'}>} [Gross Sales]), Sum({<$-(<Country = {'A'}, Company = {'A'}>+<Country = {'B'}, Company = {'B'}>)>} [Total Sales]) )

Re: Set Analysis with three measures

Kashyap_R — Fri, 29 Nov 2019 16:28:08 GMT

Can u tell me more about what you want exactly and if possible attach the output you want

Thanks

Re: Set Analysis with three measures

Brett_Bleess — Tue, 10 Dec 2019 20:52:31 GMT

Did Sunny's post get you the solution you needed? If so, be sure to return to the thread and use the Accept as Solution button on it to give him credit for the assistance and let other Community Members know that worked. Here are some other Design Blog and Help links regarding Set Analysis that may help in the future:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

If you want to search the Design Blog further, here is the base URL for that:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Help link:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

Regards,
Brett