Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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.

Highlighted
Specialist II
Specialist II

Hi Enrique,

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

Are that in QMC?

Highlighted
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.

Highlighted
Specialist II
Specialist II

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