topic Getting page to default to max month in QlikView

Getting page to default to max month

Tue, 19 Oct 2010 09:31:03 GMT

i would like my QlikView page to default to the maximum month. I have gone into sheet properties/ triggers/ Edit Action on activate sheet.

Selected select in field

Field = Month

Search String =max(Month)

but this doesn't seem to work, I have saved the application open it and it is selecting the full year which is what we previously programmed it to do. Can anyone see what i am doing wrong/

THanks

Getting page to default to max month

vgutkovsky — Tue, 19 Oct 2010 18:13:50 GMT

Create a variable that contains the following formula and call it vMaxMonth:

max(aggr(Month,Month))

. I know this is somewhat convoluted, but it doesn't work to just say max(Month) for some reason.

Then create the following macro, which you can trigger on activate or whenever:


sub selectmaxmonth
 inputVal = ActiveDocument.Variables("vMaxMonth").GetContent.String
 ActiveDocument.Fields("Month").Select FormatDateTime(inputVal)
end sub

Regards,

Getting page to default to max month

Thu, 21 Oct 2010 16:36:04 GMT

when you say create the following macro - where do i create it? in the script or is it in sheet properties/ triggers

Thanks

Getting page to default to max month

vgutkovsky — Thu, 21 Oct 2010 20:29:10 GMT

CTRL+M or Tools --> Edit Module.

Getting page to default to max month

rwunderlich — Fri, 22 Oct 2010 01:22:51 GMT


ATucker1 wrote:
Selected select in field
Field = Month
Search String =max(Month)

Try using maxstring() instead.

Search String =maxstring(Month)

-Rob