topic Re: Default max date selection in QlikView

Default max date selection

Mon, 09 Mar 2015 14:27:15 GMT

Hi All,

Here I have a scenario where I'm retrieving date field as 42060, 42081 number format, i converted this to proper date format as 04-Mar in list box (as per my requirement), here I need to show default maximum date when the documents gets opened.

Regards,

krishna

Re: Default max date selection

JonnyPoole — Mon, 09 Mar 2015 14:31:10 GMT

you can add an 'open document' trigger with a 'select in field' action and pass in the following expression:

=date(max( {1} Date))

where 'Date' is your Date field.

The trigger is done at Settings -> Document Properties -> Triggers.

Re: Default max date selection

alex_millan — Mon, 09 Mar 2015 14:32:20 GMT

Hi Krishna,

you can set a trigger on the document.

Settings --> Document Properties --> Triggers --> On open --> Select in Field

On field put your desired date field name

On search string put Max([your desired date field name)

Hope that helps.

Regards.

Re: Default max date selection

stigchel — Mon, 09 Mar 2015 14:37:28 GMT

You can use a trigger when opening the document (Settings\Doc properties\triggers\Document triggers\OnOpen or use e.g. a start button with trigger). Use a Select in Field trigger with your date field and an expression in the value expression like:

=Date(Max(YourDateField),'DD-MMM')

Re: Default max date selection

Mon, 09 Mar 2015 14:44:15 GMT

Hi Alex & Jonathan poole,

Thnx for the reply...I tried both before ..but its not working..let me put this in detail..my date field is [Day-Month] with following values 42054,42055,42060. here I converted this stuff to 24-feb using =Date(PurgeChar([Day-Month],'[]'),'DD-MMM') in my list box. Now when I'm trying to show the default max date values its not working. In the trigger I tried max(my field name) n also max(=Date(PurgeChar([Day-Month],'[]'),'DD-MMM') ..but no use.

The same thing is working fine when I try it in the text object...not sure why its behaving this way...

Regards

Krishna

Re: Default max date selection

JonnyPoole — Mon, 09 Mar 2015 14:52:26 GMT

Piet's post above was my next guess.. so maybe you can post your QVW with some sample data in it next ?

Re: Default max date selection

Mon, 09 Mar 2015 15:08:39 GMT

Hi All,

Please find attached qvw file .. !

Regards,

Krishna

Re: Default max date selection

stigchel — Mon, 09 Mar 2015 15:21:47 GMT

Trigger select in field Day-Month with in value field:

=Max(Num#([Day-Month]))

Re: Default max date selection

JonnyPoole — Mon, 09 Mar 2015 15:24:27 GMT

i'd suggest fixing your date load in the load script . otherwise the trigger needs to invoke the same purgechar() expression.

Here is a working example of the select in field action WITHOUT fixing the load script:

max( {1} PurgeChar([Day-Month],'[]'))

Re: Default max date selection

Mon, 09 Mar 2015 15:32:17 GMT

Thnx Piet, Its working now, I tried the same thing before but don't know why it didn't worked...

Regards

Krishna