topic setting static min and max in a macro in QlikView

setting static min and max in a macro

Thu, 06 Oct 2011 05:27:47 GMT

Quick question to anyone who knows:

I have a line chart showing several expressions. the x axes is a time scale (~6 years) . I have set up 3 buttons at the top of the graph. I want to

write a macro that shifts the time scale from max (6 years) - to 3 years before present, 2 years before present and 1 year before present and scale the graph acccordingkly.

I'm not sure how to do this - I was thinking there would be a property .staticmin or something similar for a member of the graph object (I guess a dimension) - but it seems there is none.

help appreciated.

Re: setting static min and max in a macro

lironbaram — Thu, 06 Oct 2011 10:24:53 GMT

hei

attach is an example

have a look if it helps you

look at the calculated Dimension expression

Re: setting static min and max in a macro

Fri, 07 Oct 2011 02:59:56 GMT

Thanks a lot for that. I'll see if I can modify it and make it work in this application.

It would be great if there was aQlikview page that fully defined the chart object - with proper descriptions of every possible object/method. The API guide is OK - but does not cover everything