topic Bar To Line Change in QlikView

Bar To Line Change

its_anandrjs — Mon, 25 Jul 2011 18:52:40 GMT

Hi All,

Is ther any way i change the type of the Bar Chart change from Bar Chart to Line Graph or any other types of chart. This all done in the Qlikview envireonment ny the help of any Macro or any other way please provide help for that.

Anand

Regards.

Bar To Line Change

erichshiino — Mon, 25 Jul 2011 19:04:41 GMT

Hi,

instead of a field with the options you can enable the fast change.

On the object properties, general tab, botton of the windows on the right, you can enable as many types as you want and choose an icon on the title or in the chart.

After you confirm, you will have a button (available to all users) to make this 'fast change'

If you really want to use it on a field, I would create many versions of the charts and make them visible or invisible according to selections. ..

Hope this helps,

Erich

Bar To Line Change

swuehl — Mon, 25 Jul 2011 19:06:35 GMT

Hi,

on General tab of properties, click bar and line chart in section "fast type change" right bottom section of tab.

Then, you can change chart type in graph caption, right upper part.

Stefan

Bar To Line Change

Anonymous — Thu, 28 Jul 2011 11:52:37 GMT

See the screen shot to add the option "Fast Change" to change the chart type. Under the heading Fast Type Change choose the chart types you need to view.

Re: Bar To Line Change

kgarvind — Sat, 21 Jun 2014 14:43:21 GMT

I have an issue where i have 3 charts selected for fast change - but when i change from Bar to Pie - at the background the bar chart stays and chart overlays on the top - if i move next to Pivot it is fine and back to bar is fine.

anything i am missing?

Re: Re: Bar To Line Change

Sat, 21 Jun 2014 15:28:11 GMT

I couldn't open you qvw file as using personal edition. I have created a sample qvw. It has 2 ways to achieve toggling of charts. First by using list box & other by using fast change option.

Re: Bar To Line Change

antoniotiman — Sat, 21 Jun 2014 18:09:01 GMT

Hi Anand,

You remember You can use container.

The effect is the same that You want.

Regards,

Antonio

Re: Re: Bar To Line Change

its_anandrjs — Thu, 03 Jul 2014 17:11:17 GMT

Thanks all, This post is too old post and i achieve this by many approaches few are i mention below.

1. By the use of Inline table and add the chart type

LOAD * INLINE [

Chart Type

Bar Chart

Line Chart ];

Bar Chart or Line Chart and then use combo chart and create two expression one as Bar and second as Line

and use conditional in the chart for bar i use

=GetFieldSelections(ChartType) = 'Bar Chart'

And for line chart i use

=GetFieldSelections(ChartType) = 'Line Chart'

2. Use two charts and conditionally activate and deactivate by the use of the Layout properties.