topic Macro to select value in variable in QlikView

Macro to select value in variable

Anonymous — Thu, 01 Jul 2010 20:09:29 GMT

Hy everybody,

I have a application where I need a botton that selects the last X minutes (in the example bellow I'll use 15 minutes).

I've tried something like that:


Variable =>
time1 = =date((LocalTime() - 0.010416), 'DD/MM/YYYY hh:mm:ss') ==> returns the last 15 minutes
Macro=>

sub last
 set x= ActiveDocument.Fields("Opening_Date")
 
 WHILE y = (Opening_Date >= time1)
   x.toggleselect y
 
 WEND


end sub

The macro says that is ok, but nothing is selected.

Any suggestions?

Thanks,

Leandra Scordamaglia

Macro to select value in variable

fernandotoledo — Thu, 01 Jul 2010 21:56:41 GMT

When this variable is created? If it´s in the script it should work, if not, you should use the EVALUATE function in the macro to calculate that expression´s result and use that in the selection command.

Macro to select value in variable

Anonymous — Fri, 02 Jul 2010 13:31:31 GMT

Fernando,

The variable is not in the script because if it was there it wouldn't represent the last 15 minutes, it would be the last 15 minutes from the last reload, right?

Could you give an example how to use the EVALUATE function?

Thanks,

Macro to select value in variable

rwunderlich — Mon, 05 Jul 2010 23:05:45 GMT

Leandra, what version of QV?

-Rob

Macro to select value in variable

Anonymous — Tue, 06 Jul 2010 13:05:10 GMT

QV 9

Macro to select value in variable

rwunderlich — Tue, 06 Jul 2010 22:16:52 GMT

For version 9, try using Actions instead of a macro. In the button add action 'Select in Field'. Set the Field value to Opening_Date. For the search string use:

='>' & timestamp(now(1) - MakeTime(0,15,0))

Note I'm assuming "Opening_Date" is a real timestamp. You may have to adjust somewhat to make the select string format match your data format.

See attached qvw for working example.

-Rob

Macro to select value in variable

Anonymous — Thu, 08 Jul 2010 13:29:53 GMT

Hey, Rob.

Thanks very much for your answer and suggestion.

We'll try it in my data model.

Once again, thanks.

Leandra Scordamaglia