topic Re: Macro for dynamic chart in QlikView

Macro for dynamic chart

khan_imran — Fri, 07 Apr 2017 14:31:48 GMT

Hello All,

I have a requirement to have dynamic chart based on selection from particular fields. In attached app, I am able to change the chart type from line chart to straight table or vice versa(through macro).

Now, I would like to have an addition of some codes in existing macro which will defined chart type basis on my selection from account field.

For example: If i select Account 1 then it will show scatter chart, if I select Account 2 then it will show line chart and if I select Account 3 then straight table will be the view.

Below is the macro which i have used in attached app.

sub SetChartType

set chart = ActiveDocument.GetSheetObject("CH04")

intObjectType = chart.GetObjectType

if intObjectType = 15 then 'is currently a line chart

chart.SetChartType 2

else

chart.SetChartType 4

end if

end sub

Kindly advise how to write in macro to achieve above output.

Regards,

Imran Khan

Re: Macro for dynamic chart

hector_munoz — Fri, 07 Apr 2017 15:30:07 GMT

Hi Imran,

It looks like you have the same problem someone had once... Look at this thred:set Chart Type

, and if you need additional help let us know.

Regards,

Re: Macro for dynamic chart

khan_imran — Sat, 08 Apr 2017 09:26:31 GMT

I need some macro which will change the chart type based on field selection. I have mentioned my requirement in my original post.

Regards,

Imran Khan

Re: Macro for dynamic chart

hector_munoz — Sat, 08 Apr 2017 15:17:12 GMT

OK... Take a look to the attached sample.

Regards,

Re: Macro for dynamic chart

khan_imran — Sun, 09 Apr 2017 10:30:01 GMT

Thanks for solution, but how would you do that? I want to have just 3 charts i.e. Line Chart, Scatter Chart and Bar Chart.

Regrads,

Imran Khan

Re: Macro for dynamic chart

hector_munoz — Sun, 09 Apr 2017 11:30:22 GMT

OK Imran,

Step by step:

Create a chart of one of the desired types (eg bar chart) and select the type of compatible charts in fast change menu. In the below sample, we create a bar chart with fast change to bar chart, line chart and scatter chart. Take note of the objetc ID because we will need it when creating the necessary macro (in this case CH01):
In script, create an INLINE table with the combination of the description of charts and its code in Qlik inner codification:

MASTER:

LOAD * INLINE [

ID, DESC

0, Bar

3, Scatter

4, Line

];

In designer, create a field box with the description for letting the user to select the desired chart and a variable that contains tha max value of the field.
Create a macro that allows the application to change the chart as the user selects the chart.
Associate the macro to the variable change: Settings > Document Settings > Triggers > Field Event Triggers > Variable Event Triggers + OnInput and OnChange

I attach you another app.

Regards,
H

Re: Macro for dynamic chart

marjan_it — Sat, 23 Feb 2019 10:05:50 GMT

can I do this for drilldown select in dimention?