Yeah, I'm struggling a bit here.
This is probably more of a design question. I need to control the selections in the filter pane, and then drive the calculations. This problem breaks everything that QlikSense is meant to do!
So - from the top.
Here's my dashboard - I want you to pick a code on the left (1. Pick a procedure code.)
This gives you a set of possibles in 2. Select one or more Consultant in Step2.
This then needs to remove the step 2 selection from the step 3. Filter peer group.
Then Step 2 filter pane needs to drive Mean Op Time (Selected) and Step 3 filter pane needs to drive Mean Op Time (Peers).
I can do more advanced calculations, once I've figured out HOW to wire this stuff up
Here's a screenshot.
Your question is very valid and there are many examples where we need to compare one scenario to other "possible" scenarios. The most comon example is when we want to compare a sales guy performace in a region towards the other sales guys in the same region.
In Qlikview this is easy handled in what is called Alternate States - but there is not yet the same functions in Sense standard application.
However we can create it in Sense by SET analysis and Data Islands.
To do what is needed, we need to create two new tables where the selections are made.
So in my script I have the Data table, and from that table I create two new tables:
Consultant as ConsultantChoice1
Consultant as ConsultantChoice2
Then I drop those on the canvas like normal filter panes, and the first KPI indikator use the folowing expression:
This expression display the sum of value for the choosen consultant in the filter pane for Consultant1
while the second KPI uses this formula:
This expression display the average of values for the possible consultants available in Consultant2
I made an example qvf that has your kind of setup. Have a look at it and see if it solves your problem.
SenseAlternateState.qvf 176.0 K