Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prabunakil
Contributor III
Contributor III

Document on Open show current month and year

Hi , can i check how we define the document to open and show the latest current month and year. 

My month field is as per below:

MonthWord:
LOAD * INLINE [
TransactionMonth, TransactionMonth1
04, 01.APR
05, 02.MAY
06, 03.JUN
07, 04.JUL
08, 05.AUG
09, 06.SEP
10, 07.OCT
11, 08.NOV
12, 09.DEC
01, 10.JAN
02, 11.FEB
03, 12.MAR

];

 

My Fiscal  Year is like

2015/2016

2016/2017

2017/2018

2018/2019

Please help. 

Labels (1)
1 Solution

Accepted Solutions
uacg0009
Partner - Specialist
Partner - Specialist

Hi,
I think you can create 2 "selection in field" actions in onopen, one for year, another for month.
For "month",
Field is your month field name
Search String : =num(month(Today()))
Please try.
Aiolos Zhao

View solution in original post

5 Replies
uacg0009
Partner - Specialist
Partner - Specialist

Hi Prabunakil,

1.Click "Settings"

2.Choose "Document Properties"

3.Choose "Triggers" tab

You can find a "OnOpen" selection in Document Event Triggers

And you can add actions that you want like a button.

Thanks.

Aiolos

prabunakil
Contributor III
Contributor III
Author

Hi Aiolos 

I am following the on event, but the month did not take effect. Please advise it. 

uacg0009
Partner - Specialist
Partner - Specialist

Hi,
what kind of value in in your "month" column?
could you please give a sample?
and today is in December, so you want to show December right?
prabunakil
Contributor III
Contributor III
Author

Hi

 

My value in month is 

01 02 03 04 05 06 07 08 09 10 11 12

Yes showing December and year is 2018

uacg0009
Partner - Specialist
Partner - Specialist

Hi,
I think you can create 2 "selection in field" actions in onopen, one for year, another for month.
For "month",
Field is your month field name
Search String : =num(month(Today()))
Please try.
Aiolos Zhao