topic Re: Combo chart with Two Dimension & Two Expression in QlikView

Combo chart with Two Dimension & Two Expression

Wed, 14 Jan 2015 12:19:23 GMT

Hi,

I have a combo chart in which two dimensions are Month & Company. I write two expression One is the Sum(Sale) another one is the Growth % . I show thw first expression as a stack bar. My X axis repesent the month and the stack represent the diferent company. I want to show the Growth% month wise in this same object as a Line but exclude the company i.e Growth% show the month wise value for all company not required the company filter.

Regards

Anup

Re: Combo chart with Two Dimension & Two Expression

Colin-Albert — Wed, 14 Jan 2015 12:26:14 GMT

A combo chart cannot combine a stacked bar and a line chart.

Re: Combo chart with Two Dimension & Two Expression

Wed, 14 Jan 2015 12:40:24 GMT

Thank You Colin for your reply. Are you sure? It's not possible?

Re: Combo chart with Two Dimension & Two Expression

rajkumarb — Wed, 14 Jan 2015 12:41:44 GMT

HI Anup

You Can Make use of a Cyclic group Included for that as combo Combine a stacked bar and a line chart

Re: Combo chart with Two Dimension & Two Expression

Wed, 14 Jan 2015 13:09:32 GMT

Sorry Raj I did not get you. Can you please elaborate your proposal.

Regards

Anup

Re: Combo chart with Two Dimension & Two Expression

rajkumarb — Wed, 14 Jan 2015 14:32:08 GMT

Hi Anup

In your combo Chart create your first expression Growth% month wise

then add the your second expression and group it

this will bring the both chart into one and you will have an option to move between them

Re: Combo chart with Two Dimension & Two Expression

marchoctober — Wed, 14 Jan 2015 16:12:14 GMT

You could also go in dirty way and make one chart on anoter with transparent background))))

But otherwise, you should simplify your vizualisation and the meaning you provide in it, as user sometimes could hardly interract with what developer provides him. Other words, why don't you use two charts, one shows Time & Company, another one Growth% in a manner you like!

Re: Combo chart with Two Dimension & Two Expression

Mon, 19 Jan 2015 13:11:29 GMT

Hi all I find a solution for my question this is if your one dimension is fixed then create a combo chart with a single dimension and then create multiple expression for different dimension value wise.