topic Re: Macro not working. in QlikView

Macro not working.

Mon, 04 Aug 2014 09:41:43 GMT

Hello,

I have been asked to fix a Qlickview application for my company that the old Technician made.

The application get information from a database and show it in a list, the thing that not is working is the selection(filter function)

It's VB Script.

This work:

ActiveDocument.Fields("TIME_STAMP").Select (">=" & date() & " 04:30:00 <=" & date() & " 12:30:00")

This don't work

ActiveDocument.Fields("TIME_STAMP").Select (">=" & date() -1 & " 05:36:00 <=" & date() & " 05:36:00")

But if i change it to

ActiveDocument.Fields("TIME_STAMP").Select (">=" & date() -1 & " 05:36:00 <=" & date() & " 07:36:00")

then it works...

Can someone please help me what to do, im very new to qlickview.

Best regards

Pontus

tresB — Mon, 04 Aug 2014 09:51:10 GMT

Mon, 04 Aug 2014 11:00:27 GMT

The problem now is the database so the application is empty of data, but i think you can se the functions..

m_woolf — Mon, 04 Aug 2014 12:11:08 GMT

Read this: