topic Default selection - current month in QlikView

Default selection - current month

Mon, 17 Mar 2014 15:11:05 GMT

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

Re: Default selection - current month

Mon, 17 Mar 2014 15:20:45 GMT

Sorry for the misunderstanding - It worked now..

Re: Default selection - current month

alexandros17 — Mon, 17 Mar 2014 15:22:45 GMT

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

Re: Default selection - current month

marksmunich — Mon, 17 Mar 2014 15:23:58 GMT

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.

Re: Default selection - current month

its_anandrjs — Mon, 17 Mar 2014 15:25:01 GMT

Hi,

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

Thanks & Regards