Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sorry for the misunderstanding - It worked now..
=Left(MonthName(Today()),3)
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.
Hi,
I thing your trigger is ok do 1 thing place this code in place of =Month(Today(1)) equal sign
Thanks & Regards