A grid chart needs two dimensions to function, and an expression to plot the points over. I don't think you need an alternate state to compare here, unless you wanted it to be separate to all your other charts in selection?
If you create a grid chart with Company and TestType as your dimensions, then simply add Avg(Result) as your expression, you should see a comparison for all companies over all tests in one place. Using a company listbox, if you select 'MyCompany' and then select all the others you want to compare against, you can limit it.
Alternatively, if you change your expression to read:
This will always show your company plus any other companies you select, which may be better for what you're suggesting.
Hope this helps - if I'm way off the mark let me know!
please see attached. A little explanation - the Grid chart requires two dimensions and a single expression, while you have a single dimension and two expressions. The trick is to convert two expressions into a second dimension. You can do it using the ValueList() function. Then, in the single expression, you can test the current value of the ValueList() and provide the corresponding calculation.
I'm explaining this and many similar solutions in my new book QlikView Your Business that's coming out in April. Check it out on Amazon!
www.masterssummit.com - take your QlikView skills to the next level!
GridComparison.qvw 154.8 K
The problem is I don't want to see the details of all the other companies - I want to compare the result of my company with an average of other companies I've selected (not including my company).
Essentially I want the central bar chart that is in the attached example to be in a grid ... but I can't figure out if it's possible!
You have inspired me to test something else though. If I have a mapping table that groups all other companies as one group and then my company in a different group and use these as the dimension in place of company this then works! Now just to check if this works with the rest of the application!
Many thanks - very helpful!
GridComparisonV2.qvw 164.8 K