Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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

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

Highlighted
Contributor III
Contributor III

Hi Aiolos 

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

Highlighted
Partner
Partner

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?
Highlighted
Contributor III
Contributor III

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

Highlighted
Partner
Partner

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