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:
Solved! Go to Solution.
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?
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
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.