topic Re: change chart type in QlikView

change chart type

MauriceLudo — Fri, 14 Oct 2016 13:00:33 GMT

Hello,
I would like to please whether we can change the chart type from an external button.
thank you.
Thanks,
Maurice

Re: change chart type

marcus_sommer — Fri, 14 Oct 2016 13:12:23 GMT

This would be only with the use of macros possible which aren't recommended within the gui. An alternative could be to create several different charts and toggle with a button per variable their visibility (option within the tab layout).

- Marcus

Re: change chart type

Fri, 14 Oct 2016 13:34:06 GMT

In addition to Marcus Sommer;

Example: create a button (text: bar chart). Add an action to it: Actions > External > Set variable

Variable name for example 'vChart_Type', with value: Bar_Chart

Now in your bar chart go to the layout tab > Show - Conditional > vChart_Type='Bar_Chart'

This should do the trick; your chart is only visible when the variable vChart_Type is equal to 'Bar_Chart'

You can now create a second button with the same action, but with another value. E.g. Line_Chart

Now in your line chart go to the layout tab > Show - Conditional > vChart_Type='Line_Chart'

This should do the trick; your chart is only visible when the variable vChart_Type is equal to 'Line_Chart'

There are some more options you can use, for example a 'switch button' which evaluates the value of the variable first before changing it. This is done with an IF-function; plenty of examples here on the forum.

Re: change chart type

el_aprendiz111 — Fri, 14 Oct 2016 16:16:18 GMT

Hi,