topic Re: Regarding Macro issue in QlikView

Regarding Macro issue

d_koti24 — Fri, 22 May 2015 14:44:29 GMT

Hi ,

I have a One list box,that list box contains the date field like:

02/18/2015,

02/20/2015,

02/21/2015.

, my requirement is I want to select the max date(02/21/2015) in that date field dynamically through macro(vbscript),how to achieve this,plz help me on this.?

Regrds,

dk.

Re: Regarding Macro issue

petter — Fri, 22 May 2015 15:03:14 GMT

Actually you can do that without a VBScript Macro ... If you click on the search for the list box and type in

=Max(FieldName) and press enter then you can save a bookmark and in the options when saving select that it should be applied on top of current selections when using the bookmark later....

What is saved in the bookmark is not a snapshot of the max date but the expression you typed in the first place.

So then you have the dynamic search you need - in a bookmark.

Re: Regarding Macro issue

m_woolf — Fri, 22 May 2015 15:03:30 GMT

Why use a macro when this is easily done with actions?

Re: Regarding Macro issue

awhitfield — Fri, 22 May 2015 15:07:12 GMT

Hi koti,

you can do this easily using triggers, how do you intend to activate the selection?

Andy