Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

erisman20
New Contributor

Alternate State Set Analysis Help

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:

IdValue
110
211
312
414
515

State 2:

IdValue
612
713
814

Result:

IdValueRank
1106
2115
3124
State 2133
4142
5151
1 Solution

Accepted Solutions
MVP
MVP

Re: Alternate State Set Analysis Help

Check the attached image and qvw sample

Capture.PNG

16 Replies
MVP
MVP

Re: Alternate State Set Analysis Help

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
New Contributor

Re: Alternate State Set Analysis Help

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.

MVP
MVP

Re: Alternate State Set Analysis Help

So, you mean different IDs will be selected?

erisman20
New Contributor

Re: Alternate State Set Analysis Help

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

MVP
MVP

Re: Alternate State Set Analysis Help

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
New Contributor

Re: Alternate State Set Analysis Help

I can convert it from Qlikview to Qlik Sense.

MVP
MVP

Re: Alternate State Set Analysis Help

Check the attached image and qvw sample

Capture.PNG

erisman20
New Contributor

Re: Alternate State Set Analysis Help

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

MVP
MVP

Re: Alternate State Set Analysis Help

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.