topic Re: 2-dimension / 2-expression bar chart question in QlikView

2-dimension / 2-expression bar chart question

Tue, 05 Nov 2013 14:36:48 GMT

Hi, I'm brand new to QlikView!

I am trying to develop a bar chart with 2 dimension levels, and I was hoping to get two expressions to display as side-by-side bars, but I can only get them to stack. I've attached 2 images, one showing what i've been able to get in QlikView, the other showing what I'm trying to get to.

I am seeking either:

Advice on how to go about achieving my goal in QlikView, if it's even possible, or;
Suggestions on displaying something similar to what I am looking for that might be better/enhance user experience/etc.

Thank you for any suggestions or input.

Re: 2-dimension / 2-expression bar chart question

Tue, 05 Nov 2013 14:56:27 GMT

Hmm... I am still working on the side by side piece but this is one step closer to what you are looking for....

Re: 2-dimension / 2-expression bar chart question

Tue, 05 Nov 2013 15:11:21 GMT

I am still evaluating QlikView for my company and only have Personal Edition and have exceeded my qvw import limit. Can you perhaps describe what you've done and I can attempt to mimic it?

Re: 2-dimension / 2-expression bar chart question

Gysbert_Wassenaar — Tue, 05 Nov 2013 16:02:10 GMT

That layout is not possible afaik. You can use three dimensions and an expression or two dimensions and N expressions. But you'll get groups of stacked bars, not groups of grouped bars.

Re: Re: 2-dimension / 2-expression bar chart question

Josh_Good — Tue, 05 Nov 2013 19:32:45 GMT

Tom,

Here are two possible solutions. The first one combines the Quarter and the Level into a single dimension so you get the display you are looking for however the labels are now Quarter-Level (e.g. Q1-Key). The second solution uses a grouped expression so you can look at count or sales.

-Josh

PS I used my special powers as a QlikTech employee to make it so you can open the QVW with personal edition (this will expire at the end of January 2014).