Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
JustinDallas
Specialist III
Specialist III

Alternate States-Show Combined Dimension Selections Across States

Hello Folks,

I'm working with Alternate States in QlikSense.  What I would like to have is a table that has a dimension that shows the selections in ALL of the states.

 

I'm using this for my dummy data:

[States Test]:
Load * Inline
[
    'States Text', 'States Value'
    Deffy State #1, 4
    Deffy State #2, 17
    Alt State #1, 35
    Alt State #2, 74
    Alt State #3, 98
]
;
Exit Script
;

 

What I would like to see is when I select different values in the different states filter panes.  The image below shows the empty table.

Alternate States.png

 

What I am expecting is something like this:

 

Alternate States 2.png

 

Currently, I have this as my dimension code, but it doesn't work 

Aggr(Only({"Alternate State"*$}[States Text]),[States Text])

 

I've tried other techniques such as using "+" and "/", but they never quite work out.

 

Any help is greatly appreciated.

Labels (3)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Combine selections on different states using a measure 

 

vinieme12_0-1682477266758.png

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

3 Replies
vinieme12
Champion III
Champion III

Combine selections on different states using a measure 

 

vinieme12_0-1682477266758.png

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Prem0212
Creator
Creator

first of all we have to create two different master items like Group 1 and Group 2  and assign those master items to the required filters or dimensions or measures and u can check comparitive Analysis

JustinDallas
Specialist III
Specialist III
Author

In addition to using the measure, I had to combine the states since I had filters on my Set Analysis.  Below is an example of what worked.

 

Sum({$<[My Field]={'Field A'}>} Value) + Sum({"Another State"<[My Field]={'Field A'}>} Value)