topic Re: How To Display Two Measures in a Bar-Line Chart in QlikView

How To Display Two Measures in a Bar-Line Chart

Thu, 29 Aug 2013 10:04:16 GMT

Hi ,

How To... Display Two Measures in a Bar-Line Chart (is there any way instead of split axis and position) and is there any limitations to use more metrics(min 4) and dimensions ?

Can any one please let me know how it will work?

Thanks & Regards,

Sh.

Re: How To Display Two Measures in a Bar-Line Chart

jjordaan — Thu, 29 Aug 2013 10:28:15 GMT

You can use the split Axes option in the Axes tab or just add a second expression and set the style to grouped in the style tab

Re: How To Display Two Measures in a Bar-Line Chart

Thu, 29 Aug 2013 10:48:22 GMT

Hi,

Thanks for the reply , but while trying that grouped option is in inactive,

Can you please let me know how to resolve it ..

Thanks & Regards,

Re: How To Display Two Measures in a Bar-Line Chart

jjordaan — Thu, 29 Aug 2013 10:51:09 GMT

Maybe you can try this.

1. Add 2 dimensions

2. Set the style to grouped

3. Add second expression

4. Delete one dimension

It works for me

Re: How To Display Two Measures in a Bar-Line Chart

Thu, 29 Aug 2013 11:14:58 GMT

Hi,

Thanks again for the replay , but in my chart using more than 15 dimensions and 4 metrics,

and it is working fine when i select 1 dimension and 1 metric (showing dimension in x-axis and in y-axis metric value),

my requirement is need 2 y-axis (right and left) , and dimensions in x-axis for that we used split axis and position options , but it is working fine when i select 2 metrics , while selecting second metric it is showing in right side , this is not fine for the business it has to come in left side,(and business want this for all 4 measures),

Is this possible to achieve?

Thanks & Regards,

Re: How To Display Two Measures in a Bar-Line Chart

jjordaan — Thu, 29 Aug 2013 11:21:41 GMT

Is it possible to send me the QVW or test version of it so I can look into it?