topic Re: Outer Set Analysis with Master Elements in Move to Qlik Cloud Analytics

Outer Set Analysis with Master Elements

Danijel — Tue, 27 Jan 2026 10:45:26 GMT

Hello,

I am currently trying to extend a new master element based on another master element including outer function:

As an example:
Master element 1= Sum({$<Year={2012}>} Sales)
Masterelement 2= {<Country={'Germany'}>} Master Element

The problem, it does not work. As soon as there is a Set Analysis in the upstream master key figure, there is no reaction. As long as I remove it, it works.

Bug or feature?

Thanks and greetings

Re: Outer Set Analysis with Master Elements

Frank_S — Fri, 04 Aug 2023 22:19:11 GMT

Hi @Danijel

Try this as a single master measure

{<Country={'Germany'}>}Sum({$<Year={2020}>} Sales)

This works.

The set analysis {<Country={'Germany'}>} doesn't work when using the function editor at all.

It works when combining as above.

I believe it is by design.
kind regards...

Re: Outer Set Analysis with Master Elements

cristianj23a — Fri, 04 Aug 2023 22:51:34 GMT

Hello, I understand that you want to obtain the sales in the year 2012 of the country Germany. If so, I send you an expression.

Sum({<Year={'2012'}, Country={'Germany'}>} Sales)

regarts.

Re: Outer Set Analysis with Master Elements

Danijel — Mon, 07 Aug 2023 06:45:01 GMT

Thank you for the answers.

I already know the suggestions, but I have a "basic formula" that I would like to reuse in other master elements.

Therefore, the suggested methodology is unfortunately of no use to me. I used to implement this with variables and placeholders.

I will create another idea for this.

Re: Outer Set Analysis with Master Elements

Vishal_Gupta — Mon, 28 Aug 2023 09:37:12 GMT

@Danijel I would rather suggest you to use variables and master items in combination.

variables can store your outer set expression, for example:

eOuterExp1 = {<Country={'Germany'}>} eOuterExp2 = {<Year={2012}>}

master item can store lowest level of expression without any set analysis, for example: Sum(Sales)

then combine them for better reusability

$(eOuterExp1)$(eOuterExp2)Master Item

Re: Outer Set Analysis with Master Elements

marcus_sommer — Mon, 28 Aug 2023 13:29:53 GMT

Beside of the feature of the master elements I'm not sure if the combination of inner and outer set analysis is possible and also sensible as a general approach. Like by the work with variables the aim is to simplify the development and maintaining and by an overuse it reverts easily into the opposite. Background to these thoughts is the following discussion:

Outer SetAnalysis modifier ignored - Qlik Community - 2108889

Maybe it's related to your scenario.

Re: Outer Set Analysis with Master Elements

Vishal_Gupta — Mon, 28 Aug 2023 13:51:43 GMT

@marcus_sommer I agree with you on this. Also, we usually do not have set expressions defined to a specific year/month or date rather it is relative or dynamic. So having a variable which stores dynamic values reduces the redundancy of creating multiple objects that needs to be maintained.

Re: Outer Set Analysis with Master Elements

Ravi_Nagmal — Fri, 01 Sep 2023 08:04:31 GMT

@Danijel Try Some thing like this it will work.

{<Year={2012}>} ({<Country={Germany}>} Master Item)

Re: Outer Set Analysis with Master Elements

vasilev — Fri, 09 Aug 2024 13:40:19 GMT

Hello @Danijel,

You should remove the $-sign from your expression. Then it should work.

Master element 1= Sum({<Year={2012}>} Sales)

You can read about the inheritance rule here:

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysis/set-expressions-inner-and-outer.htm

BR,

Rumen