Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

1adam_haj
New Contributor III

Current month button

hello,

i am using Sheet Navigation + Actions buttons for Qlik Sense extension and I need to make button for selection of current month


In field of selections i have this field

 

='Stop_Time.autoCalendar.YearMonth'


and in field for value i have tried following script


=date(makedate(year(today()),month(today()),day(today())),'YYYY-M')


- this script is returning right value = 2018-2


So i can´t get where is the problem. Any ideas ?

1 Solution

Accepted Solutions
qlik4asif
Contributor II

Re: Current month button

4 Replies
qlik4asif
Contributor II

Re: Current month button

agigliotti
Honored Contributor II

Re: Current month button

are you sure both field values match?

what's the data type of "Stop_Time.autoCalendar.YearMonth field ?

1adam_haj
New Contributor III

Re: Current month button

It is string in timestamp format like this: YYYY-MM-DD HH:MMSmiley FrustratedS

It is recognized and driven by QS autocalednar, autocalendar functions like YearMonth or Month are working right

agigliotti
Honored Contributor II

Re: Current month button

that's why it's not working.

you should use the same date format.

Community Browser