DEFAULT SELECTION IN A DATA FIELD

[eduardo_dimperio]

Hi !

After some friends help i could make my date selection. But now i need to set a default value as current month. The problem is set analysis doesn't work cause its not a measure to use SUM,MAX and etc.

Can use bookmark either, cause tha value change every month.

There some way to get today() and use that to set focus?

DATA_SELECAO:

LOAD date(floor(monthstart([Entrada Desenv.])),'MM/YYYY') AS DATA_SELECAO

RESIDENT AVALIACAO_ANALISE

ORDER BY [Entrada Desenv.]ASC;

;

Thank you

[eespiritu]

Hi Eduardo,

You can use a trigger and select the current day in your field. Go to Setting - Document Properties - Triggers tab, in Document Event Triggers, select 'OnOpen' and then clic on Add Action(s)... button. Clic on Add button, Action Type: Selection, Action: Select in Field, next step is put your field name in the Field box and in Search String box put:  = today().

As you know, you must use the same date format.

Regards,

Enrique.

[eduardo_dimperio]

Hi Enrique,

Sorry asking this, but where i can find the settings on the Qlik Sense?

Are that in QMC?

[eespiritu]

Oh I thought that I was in QlikView. Anyway, I found this, could it helps:
Open dashboard to current month | Qlik Community

Go directly to Jonathan Poole's answer.

[eduardo_dimperio]

Unfortunately it's doesn't work cause they are selecting only the current month and i want all data select current month by default.