Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
eduardo_dimperio
Specialist II
Specialist 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
Creator
Creator

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
Specialist II
Specialist II
Author

Hi Enrique,

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

Are that in QMC?

eespiritu
Creator
Creator

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
Specialist II
Specialist II
Author

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