Current month button

[1adam_haj]

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 ?

[qlik4asif · Accepted solution]

@Controlling variables for buttons in qliksense

Button feature for QlikSense

[agigliotti]

are you sure both field values match?

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

[1adam_haj]

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

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

[agigliotti]

that's why it's not working.

you should use the same date format.