Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
erisman20
Contributor III
Contributor III

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
16 Replies
erisman20
Contributor III
Contributor III
Author

How would you add the Standard deviation of the new set, including the "State2" value?

sunny_talwar

Check the attached

erisman20
Contributor III
Contributor III
Author

Sunny,

Sorry to keep this post going:

Is there any way to do this same functionality without using straight tables?

For example, if I just wanted to create a text box with the rank of the aggregated State2 values compared to the State1.

Thanks for the help!

sunny_talwar

What would be the output look like in the text box? Can you draw a picture for me?

erisman20
Contributor III
Contributor III
Author

Using the same data values as above, I would want to be able to to do the following without using tables:

example.PNG

sunny_talwar

Getting Average value should be simple

='Average State2 Value' & Chr(10) & Avg({State2} Value)

Still trying to figure out the Rank part

sunny_talwar

For rank, try this

='State2 Rank' & Chr(10) & RangeSum(Count(DISTINCT Aggr(If(Sum(Value) > Avg(TOTAL {State2} Value), Id), Id)), 1)