Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar chart + multi Line chart

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,

C.

10 Replies
Not applicable
Author

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?