Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
stevegimbrollmt
Creator II
Creator II

Set default value selection on open of a document

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

1 Solution

Accepted Solutions
stevegimbrollmt
Creator II
Creator II
Author

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

View solution in original post

4 Replies
Not applicable

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
Creator II
Creator II
Author

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
MVP
MVP

Try this

for field Date, search string:

='=Date=today()'

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

Stefan

stevegimbrollmt
Creator II
Creator II
Author

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