Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
are you sure both field values match?
what's the data type of "Stop_Time.autoCalendar.YearMonth field ?
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
that's why it's not working.
you should use the same date format.