Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro not working.

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

3 Replies
tresesco
MVP
MVP

Could you post your sample qvw that shows the issue? See:
Preparing examples for Upload - Reduction and D... | Qlik Community

Not applicable
Author

Dropbox - test.qvw

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