topic Set default value selection on open of a document in QlikView

Set default value selection on open of a document

stevegimbrollmt — Tue, 09 Aug 2011 22:07:08 GMT

I have a document and has 3 listboxes one with a Day, Month and Year as selection options.

How can I set the Day Month and Year default selection to todays day as.

I have tried triggers or any other option but im lost, I really appriciate help

Steve

Tue, 09 Aug 2011 22:56:19 GMT

Hi Steve ,

Can you try this . Let us assume u have 3 listboxs named as Date , Month, Year

Now in document properties OnOpen can you specify these in select fields

select field

Month = subfield(Today(),'/',1)

Date = subfield(Today(),'/',2)

Year = subfield(Today(),'/',3)

if it fails to work let me know i'll try to find some other way to make it work

Thanks

Meher

stevegimbrollmt — Tue, 09 Aug 2011 23:05:32 GMT

Thanks for the tip, but no success

I have done this,

Opened Document Setttings, went to Triggers and OnOpen created 3 Select in Field

Field: Day

Search String: =subfield(Today(),'/',2)

Field: Month

Search String: =subfield(Today(),'/',1)

Field: Year

Search String: =subfield(Today(),'/',3)

Nothing happened :S

Thanks!

swuehl — Tue, 09 Aug 2011 23:10:15 GMT

Try this

for field Date, search string:

='=Date=today()'

for other fields, use ='=Month=month(today())' etc.

Stefan

stevegimbrollmt — Tue, 09 Aug 2011 23:22:27 GMT

Thank You guys your feedback helped me, to understand more

I managed now, what I did is in the Field I just wrote Day, not =Day or 'Day' etc

and as in Day i have 1,2,3,4,5 etc i had to do Num(Day(Today())) in order to change it to number, that is were it was giving me a problem.

At least I think I got the hang of it now, I really thank you again guys for your help