topic Re: Bar and Line char (Combo Char) in QlikView

Bar and Line char (Combo Char)

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

Dear All

Hope you can help with this,

i need to show a combo chart as the attached image suppose i have:

Age bracket as dimension

Bar Chart that show the volume of deposits by brackets and the line chart that is an accumulation Percentage as picture attached

thanks

Re: Bar and Line char (Combo Char)

avinashelite — Mon, 27 Jun 2016 11:13:08 GMT

Simple First the chart type should me combo chart then. Go to Chart Properties > Expression > choose the line expression and then in the bottom enable both the line and Symbol for this expression and choose the symbol format you want

Hope this helps you

Re: Bar and Line char (Combo Char)

susovan — Mon, 27 Jun 2016 11:28:33 GMT

Hi Mario,

Try this Attachment,

Re: Bar and Line char (Combo Char)

mario-sarkis — Mon, 27 Jun 2016 11:37:21 GMT

Can you please send and qvw?

and if i need to show is exactly as the picture that i attached (Percentage is a cumulatative Percentage)

Re: Bar and Line char (Combo Char)

Anonymous — Mon, 27 Jun 2016 12:07:09 GMT

Hi Mario,

You could try "accumulation" option in Expression tab of the combo chart. Additionally, you could try

rangesum(above(sum(value), 0 , rowno())) as expression .

Best regards,

Kaveri

Re: Bar and Line char (Combo Char)

Mon, 27 Jun 2016 12:12:51 GMT

Hi,

Its very simple just enable Full accumulation in expressions tab for the line under chart Properties.

hope this is helpful

Re: Bar and Line char (Combo Char)

susovan — Mon, 27 Jun 2016 12:28:44 GMT

PFA