Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What I am expecting is something like this:
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.
Combine selections on different states using a measure
Combine selections on different states using a measure
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
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)