topic Bar chart + multi Line chart in QlikView

Bar chart + multi Line chart

Thu, 27 Oct 2011 08:25:25 GMT

Hi all,

I'm trying to do a specific chart :

2 Dim :

- CATEGORY

- MONTH

2 Expr:

- Volume

- Market Share of category per month

I want :

- bar chart for the volume (one bar per category per month)

- line chart for MS (one line per category)

I'm using the Combo chart to do it but I have an issue : The line chart doesn't split per CATEGORY, I only have one line for all category.

I attached one qvw with 2 sheets :

- First with the example that I can't do

- Second the result I'm almost trying to get (for this sheet I did one expression per category, of course I'm looking for something dynamic)

Anyone has an idea ?

Thanks,

Bar chart + multi Line chart

Sat, 29 Oct 2011 19:29:44 GMT

I see just one solution.

Create 5 expression 1 bar & 4 lines

Bar = sum(VOLUME)

Line 1 = sum({<CAT={'A'}>} VOLUME)/sum(total<MONTH> VOLUME)

Line 2 = sum({<CAT={'B'}>} VOLUME)/sum(total<MONTH> VOLUME)

etc...

I'm not sure it's what you want but it works

Bar chart + multi Line chart

Mon, 31 Oct 2011 09:25:03 GMT

It's what I did on the second sheet on the attached .qvw to show the needs.

This solution works but is not acceptable because it has to be dynamic. There is lot of CAT in the system.

It seems like a bug, more than something else ... Because if I drop the expression in bar I get the lines I wanted ...

Bar chart + multi Line chart

Mon, 31 Oct 2011 09:43:56 GMT

Grid charts are often used to show the relationships in size, It would be best if you use Grid Chart.

Bar chart + multi Line chart

Mon, 31 Oct 2011 10:02:45 GMT

Can you give a real example ? Im trying to show a chart and not a list.

Bar chart + multi Line chart

Mon, 31 Oct 2011 10:13:19 GMT

you can change your chart type to Grid chart..however you can also peep into Sample apps on start up page..

have fun.

Bar chart + multi Line chart

Mon, 31 Oct 2011 10:31:48 GMT

Thank you for your help,

It tried it but the result isn't what my client want. This chart is not demonstrativ enought for these indicator

Bar chart + multi Line chart

swuehl — Mon, 31 Oct 2011 11:24:42 GMT

Hi Cyrille,

you said it looks like a bug and that's what comes to mind to many of us, but I think it is by design.

QV seems not to handle well line charts with more than one dimension, if you use more than one, you will get a line chart sampling point only at the first dimensions value on the x-axis. You might get around this if you use one dimension only, built from MONTH & CAT (maybe using an advanced aggregation to have the underlying dimensions still at hand).

With your requirements, I have (at least) one question:

You want to use two dimensions, CAT and MONTH and you want a bar for each CAT and MONTH.

This means your x-axis should span over both dimensions.

Then you want line chart, with a line per CAT. This sounds to me that here you want to use the second dim to generate a bundle of expression like output, i.e. your second dimension CAT should not be used for the x-axis, right? Not sure if I make myself clear, but for me that's kind of contradicting design requirement. So maybe you could clarify this to me.

Regards,

Stefan

Re: Bar chart + multi Line chart

hdonald — Tue, 01 Nov 2011 09:29:56 GMT

Hi,

If you have to make many expressions in a dynamic way you could use something like the macro code in one of the example Qlikview docs - 'Dynamic Chart' - here..http://community.qlik.com/qlikviews/1077

See the attached basic example that just adds 1 expression per CAT to your chart.

Looking at the the result though, it seems Stefan's suggestion to review the requirement is the best answer as it looks like 2 separate charts..which would be easier,

Regards,

Bar chart + multi Line chart

Thu, 03 Nov 2011 08:33:39 GMT

Finaly the solution with one expr per CAT is the best.

Even better when it's dynamic...

I have also a solution really dirty but it works : superposition

2 chars : one in bar the other in line and the one over the other with transparent background.

Thank you all for your help.

Re: Bar chart + multi Line chart

Mon, 23 Dec 2013 09:52:13 GMT

Hi, if i want to compare A an B, or B and C and D category, i create a listboxwhit categoryid and name :

A, A category

B, B category

C, C category

and in expresion condItion I write:

for A category : indicatorid=A

for B category : indicatorid=B

etc...

if i select one catoegory, its ok, it shows one category, but if i select 2 or more categorys its shows only volume, can you help?