Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Default selection - current month

Hi,

I am new in Qlikview,

I need help in selecting current month by default in Qlikview document,

I have a table "A" and field name "Mon"

"Mon" has month names shorten to 3 letter string i.e "Jan", "Feb", "Mar" .....

I did Settings -> Document Properties -> Document Event Triggers -> OnOpen ->
Actions : Select in Field
Field : A.Mon

Search String : Month(Today(1)).

But when I save and re-open the document, I dont see the current selection...

Am I doing something wrong?
Please Help,

Thanks,
Parth

4 Replies
Not applicable
Author

Sorry for the misunderstanding - It worked now..

alexandros17
Partner - Champion III
Partner - Champion III

=Left(MonthName(Today()),3)

marksmunich
Creator III
Creator III

It is so simple. Document Properties -> Document Event Triggers -> OnOpen -> and then enter the field name in the fieldname text box and the search string value in the text box.

In your case :

Fieldname = Mon

Search String = 'Jan'

Just Save and reload. in this case by default Jan is selected in the month field.

its_anandrjs

Hi,

I thing your trigger is ok do 1 thing place this code in place of =Month(Today(1)) equal sign

Thanks & Regards