topic Default selection on calculated field in QlikView

Default selection on calculated field

nigel987 — Mon, 20 Jul 2015 11:30:38 GMT

Hi,

I want to have some fields selected by default when opening the sheet.

Therefore I added a trigger in the document properties.

My field is names "date" and has the form 2015.05.19. I have several list boxes which show the year (=Year(date)) or the month (=Month(date)).

Okay, so when adding the trigger, I have to enter a field and a value. I would assume that my field is "date" and my selected value is =Year(today(1)).

But this does not work. The year in the listbox is not selected. Does anyone know what I am doing wrong here?

Thanks!

Re: Default selection on calculated field

swuehl — Mon, 20 Jul 2015 18:49:25 GMT

Qv tries to match a value like 2015 (=Year(today(1))) to date values (like 2015.05.19). this obviously won't work.

2015 <> 2015.05.19

Either create a year field in the script (recommended), or try a selection in date field using a search string in the action like

='>=' & Date(yearstart(today()),'YYYY.MM.DD')

Re: Default selection on calculated field

nigel987 — Wed, 22 Jul 2015 07:38:21 GMT

HI swuehl,

creating a new field in the script worked fine for me. Thanks for the advice.