topic how to make default selection with current month selected in QlikView

how to make default selection with current month selected

Anonymous — Thu, 18 Jun 2015 18:38:53 GMT

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.

Re: how to make default selection with current month selected

ramoncova06 — Thu, 18 Jun 2015 18:52:34 GMT

use on open trigger

how to set default selection

Re: how to make default selection with current month selected

MK_QSL — Thu, 18 Jun 2015 19:03:20 GMT

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