Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to get the Application to start-up with pre-configured selections ?

Hallo

I am new to the QV-community, hoping to find some guidelines for my problem:

the Application reports Sales figures, and for now I pre-select the Month and year when storing the DEV version,

so when users connect to the QV-server via Internet-Explorer, the current month is preselected, but then can change it

to review previous months.

this requires me to update the DEV-version each month, updating the pre-selection to the now new month, saving

and publishing the application to the PRD-server.

The application itself is automatically reloaidng the data from the ERP-system each night.

I am looking for a method either in the script or an advanced selection, so that on startup it defaults to the actiual month,

even when going to the next month and no manual update to the pre-selections.

Thank you

Johannes

1 Reply
luciancotea
Specialist
Specialist

Let's say you have a YearMonth field containing the first day of each month formatted to 'MMM-YYYY'.

Add a trigger on OnOpen event and run this in macro:

sub InitialSelections

   ActiveDocument.Fields("YearMonth").Select  ActiveDocument.Evaluate("Date(MonthStart(Today(), 0),'MMM-YYYY')")

end sub