topic Re: Plot values in a chart using Macro VBScript in QlikView

Plot values in a chart using Macro VBScript

Mon, 25 Nov 2013 16:31:06 GMT

Hi guys

I need to plot some values in a chart just using macro. The dimension is "Data Base" and the value is the "Final Average". How can i plot this values using just macros?

Here is the values: *(one value per iteration, at end the chart must be with all values calculated)

Can anybody help me with this problem?

Thanks

Re: Plot values in a chart using Macro VBScript

Anonymous — Mon, 25 Nov 2013 16:46:10 GMT

Quite unlikely. And, so "un-QlikView"... If there is a data in the application to use in the macro, there must be a way to build a chart using proper calculations.

Re: Plot values in a chart using Macro VBScript

Mon, 25 Nov 2013 17:03:24 GMT

Yes Michael, but this is a special case, because this values is calculated based on complex expressions that involves values of different tables and looking for each date the last 12 months values.

Resuming, the macro is done and i have already the values. Now, i just need to plot.. this is my problem.

Thank you

Re: Plot values in a chart using Macro VBScript

Mon, 25 Nov 2013 19:44:31 GMT

Try to implement all those expression in script level by joining tables and plot the table.

Re: Plot values in a chart using Macro VBScript

Wed, 04 Dec 2013 12:45:29 GMT

Ok, problem solved.

Thanks