Alternate State Set Analysis Help

[erisman20]

Hey everyone,

I am dealing with an issue I cant quite figure out. I have 2 alternate states (State1, State2) and I want to to find the rank with the values of State1, including the aggregated average from State2. See example below:

State 1:

Id	Value
1	10
2	11
3	12
4	14
5	15

State 2:

Id	Value
6	12
7	13
8	14

Result:

Id	Value	Rank
1	10	6
2	11	5
3	12	4
State 2	13	3
4	14	2
5	15	1

[sunny_talwar]

Would you be able to share a qvw sample to see your data? How are you getting different value for the same ids in the two states? Is it based on selections made?

[erisman20]

Sunny,

That was just a bad example, the values will be the same. The only thing different between the two states is the selections made.

[sunny_talwar]

So, you mean different IDs will be selected?

[erisman20]

Yes, selections will be made to filter the IDs for each state. We want the example rank calculation based on those selections.

[sunny_talwar]

One last thing... is this in Qlik Sense? I have not used Qlik Sense too much to know how to implement alternate state in Qlik Sense, I might be able to help if you can let me know how to use alternate state in Qlik Sense or I can may be help you with a solution in QlikView and you can transfer it over to Qlik Sense

[erisman20]

I can convert it from Qlikview to Qlik Sense.

[sunny_talwar · Accepted solution]

Check the attached image and qvw sample

[erisman20]

This worked great! Thank you! Can you further explain your use of "dim"?

[sunny_talwar]

Just using an island table to display two parts.

For expression, when Dim = 1, show the sum of value from State 1, when Dim = 2, show the Avg of value from state 2.

For dimension, when Dim = 1, show ID as the dimension, but when Dim = 2, show some text.