Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
1adam_haj
Contributor III
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
4 Replies
agigliotti
Partner
Partner

are you sure both field values match?

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

1adam_haj
Contributor III
Contributor III
Author

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
Partner
Partner

that's why it's not working.

you should use the same date format.