combo chart

Mon, 25 Jun 2012 12:41:22 GMT

Hello,
I need help for create an object "combo chart".
I have a table (look attached document). I should analyze my indicators by month and type. My values in the list type are not fixed. Now I only have two values (A and B), tomorrow I can have 3, 4 or more values. I want to have a presentation with bar on stacked (with different types) and two average values on line. You have an example in attached document for the expected result. The difficulty for me as my values in the list” Type” are not fixed. I must use the type as a dimension in my chart. I cannot simply set the value in an expression (for example sum ($ {<type={'A'}> Myindicator). but if I create my object in two dimensions. I cannot have bar on stacked.

Thanks for your helps

Re: combo chart

Anonymous — Fri, 29 Jun 2012 09:09:56 GMT

Load it as a cross table (using the table loader wizard to rotate so your Type's end up in one dimension, and the values in another. Then you can simply stack over the dimension holding the types.

topic Re: combo chart in QlikView

combo chart

Re: combo chart