Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
eduardo_dimperi
Valued Contributor II

DEFAULT SELECTION IN A DATA FIELD

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

4 Replies
eespiritu
Contributor

Re: DEFAULT SELECTION IN A DATA FIELD

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_dimperi
Valued Contributor II

Re: DEFAULT SELECTION IN A DATA FIELD

Hi Enrique,

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

Are that in QMC?

eespiritu
Contributor

Re: DEFAULT SELECTION IN A DATA FIELD

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_dimperi
Valued Contributor II

Re: DEFAULT SELECTION IN A DATA FIELD

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