how to make default selection with current month selected

[Anonymous]

when user logins to the qlikview app. By default current month should be selected in the app. and for the next month it should select next month as the current month.

[ramoncova06]

use on open trigger

how to set default selection

[MK_QSL · Accepted solution]

Go to settings

Document Properties

Triggers

Document Event Triggers

On Open

Add Action

Add

Selection

Select in Field

Field

InvoiceMonth

Search String

=SubField('$(MonthNames)',';',Max({<InvoiceYear = {"$(=Max(InvoiceYear))"}>}InvoiceMonth))

==========================================

Change InvoiceMonth and InvoiceYear as Month and Year or whatever field name you have.

If your Month field is having format MMM (i.e. Jan, Feb, Mar etc) use above. but if your Month field is in numeric format, use

Max({<InvoiceYear = {"$(=Max(InvoiceYear))"}>}InvoiceMonth