Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Muralidhar
Contributor
Contributor

Current month on the load of Sheet

Hi - I am creating Sheet properties > Action to open on last month (for example: Sep). However, it is not opening to September month values.

Label > Open

Action > Select Values in a field

Field > VRT_Month

Value > ='Sep'

Any help is greatly appreciated.


Thank You

Muralidhar

 

Labels (1)
1 Reply
BrunPierre
Partner - Master II
Partner - Master II

Field = Year         String Search = Max({1}Year)
Field = Month     String Search = MaxString({1<Year = {$(=Max({1}Year))}>}Month)