Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Grid Chart and Alternate States

Hi,

I am trying to use a grid chart to compare the result of two different states.

In my data there are three different tests, and a bunch of companies.  I want to compare the results from My Company against a variety of selections of other companies.  Bar charts are good (totally understand this so please don't send me messages about just using bar charts and how to deal with end users) but I'm interested in this as a query about whether it might be possible using a grid chart.  I'd hoped I'd be able to put one dimension in (TestType) and two expressions in the same way you do with bar charts.

Obviously this hasn't worked so I thought I'd ask whether it is possible to essentially have the different states as a dimension on the grid chart or whether I'm looking for something that is simply not possible.

I've attached a basic example with data ... any ideas about this would be greatly received!

Many thanks,

Emma

1 Solution

Accepted Solutions
Oleg_Troyansky

Hi Emma,

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!

cheers,

Oleg Troyansky

www.masterssummit.com - take your QlikView skills to the next level!

View solution in original post

4 Replies
morganaaron
Specialist
Specialist

Hi Emma,

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:

Avg({<Company+={'MyCompany'}>}Result)

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!

Oleg_Troyansky

Hi Emma,

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!

cheers,

Oleg Troyansky

www.masterssummit.com - take your QlikView skills to the next level!

View solution in original post

Not applicable
Author

Hi Aaron,

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!

Cheers,

Emma

Not applicable
Author

Hi Oleg,

Many thanks - this is ideal! 🙂

Cheers,

Emma