Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
hacr
Creator
Creator

Combine selection from two filters into a new chart dimension?

Hi all,

I'm trying to explore the possibilities in Qlik sense with the use of as many standard components and functions as possible. Currently I try to make a comparison sheet. In my load script I generate my two identical dimensions by:

Comparison_1:

Load comparison as comparison1

Resident Source;

Comparison_2:

Load comparison as comparison2

Resident Source;

This allows me to set up to filters controlling each their charts, which is all good.

Now I'm wondering if it's possible to combine the selections from comparison1 and comparison2 into a new dynamic dimension for my graph. The result should be to select Aabenraa from the comparison1 and Frederiksberg from comparison2, getting the shown chart.

2017-09-21_10h43_19.png

I tried looking into these functions:

Aggr()

GetFieldSelections()

Pick()

Match()

ValueList()

But I can't figure out how, or if, its possible to obtain this. Hope someone can point me in the right direction

1 Solution

Accepted Solutions
hacr
Creator
Creator
Author

A temporary solution ended up being:

Avg({$<Source={"$(=GetFieldSelections(comparison1))", "$(=GetFieldSelections(comparison2))"}>} measure)

View solution in original post

1 Reply
hacr
Creator
Creator
Author

A temporary solution ended up being:

Avg({$<Source={"$(=GetFieldSelections(comparison1))", "$(=GetFieldSelections(comparison2))"}>} measure)