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: 
Anonymous
Not applicable

how to select default in current year and current month

i have month and year's

Header 1Header 2
yearmonth
2009jan
2010feb
2011mar
2012apr
2013may
2014june
2015july
2016aug
2017sep

I have month and year in dashboard using master calendar . i will open my dashboard default will selected current year and current month.

how to write condition. please suggest.

11 Replies
Not applicable
Author

Hi Nithya,

Which object are you using to display year and month ,like list-box, or straight Table. 

Anonymous
Not applicable
Author

Hi Ramu

i am using Listbox

Not applicable
Author

Hi Nithya,

Follow the link ,the same discussion is going on,maybe this is helpfu for you

Default year and month

Anonymous
Not applicable
Author

yup, i saw the link. but there represent current month. if we move on next months that time what we can do?

it will automatically change month or default in jan only?

because i want change the month also we move on next month it self????????

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Hi,

Goto Document Settings>>Triggers>>OnOpen>>Action Type is .... Select in Field>>

Use Like below i have shown for Year

Year.PNG

Same like year, You have to for Month >> Instead of =Max(year) , if you have date fied in your data then use =Month(Max(Date) ) or =Month(Today() )

try this and let me know in case of any issue.

-Nagarjun

diego_vazquez
Contributor III
Contributor III

Hi!

Go to Configuration-> Document properties-> Triggers and create three triggers in option "On open". One trigge would be "delete all", the second trigger would be select field for the year (FIELD = your field and string = "=Year(Now())" and the month field would be the same than the year but with the month like this; "=Month(Now())"

Anonymous
Not applicable
Author

if i do clear all it will not working

Not applicable
Author

Hi nithya,

After reopen the application in particular sheet Untitled.png

select "set clear State"

devarasu07
Master II
Master II

Hi,

Try to set like below,

For month

=Month(Max({1}Date))


For year varible


= Max({1}Year)


Thanks

Deva