topic Re: Dafault Selection in QlikView

Dafault Selection

Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

Could you kindly help me, i have a list box with a concatenation of day and month i.e. 05-Jul, 06,Jul etc as Dayofmonth. I want to default select the previous day as it loads on a daily basis but its not working. I went to sheet properties > triggers field = Dayofmonth search = MAX(Dayofmonth). What am i doing wrong???

Re: Dafault Selection

boorgura — Wed, 13 Jul 2016 14:25:36 GMT

Is Dayofmonth defined in the script?

If so, is it a concatenation of date & '-' & month? In that case, the max will not work as its not a numeric, but a string.

what you could use is:

max(makedate(year(today), right(Dayofmonth, 3), left(Dayofmonth, 2)))

Re: Dafault Selection

Anonymous — Wed, 13 Jul 2016 14:26:33 GMT

maybe it is not a datefield, then max(Dayofmonth) cannot work

(does the listbox Shows the field on left or right side?)

try to define max(date#(Dayofmonth,'DD-MMM')) in trigger

Re: Dafault Selection

Wed, 13 Jul 2016 14:52:26 GMT

The script: Day(TempDate)&'-'&Month(TempDate) As Dayofmonth,

Fields are on the right side

Re: Dafault Selection

Wed, 13 Jul 2016 14:52:54 GMT

See Reply above

Re: Dafault Selection

Anil_Babu_Samineni — Wed, 13 Jul 2016 14:54:55 GMT

Brian,

You are the right, If field expression is correct from Listbox values or else share your App

Re: Dafault Selection

boorgura — Wed, 13 Jul 2016 15:50:22 GMT

Ideally - you might want to update that to date(TempDate, 'DD-MMM') as Dayofmonth;