topic Re: Using a trigger to get a Min(CalendarDate) in QlikView

Using a trigger to get a Min(CalendarDate)

paul_scotchford — Sat, 01 Mar 2014 00:19:54 GMT

Hi All

I am unable to get the below scenario to work ...

Config : QlikView Server 11.2 SR5 on a Win 2012 box

1: Date Dimension of Years, Months, Dates

2: OnSelect Action on the Years Dimension

Scenario:

User selects the Year e.g. 2013

Requirement:

OnSelect trigger to Set Variable with a search string = Min(CalendarDate)

Expected Result:

variable should now have the Min Date of the selected year e.g. '1st Jan 2013' value

Result:

The variable does not change!

I know the trigger works as I can use a literal and plug it into the variable, I thought though that I would be ok using the Min() function to get the start date of the Year selected.

Clearly I am missing something or its just not supported by QV?

Thanks in advance

Paul

Re: Using a trigger to get a Min(CalendarDate)

Sat, 01 Mar 2014 01:17:15 GMT

Hi Paul,

You can use the function MonthStart function to obtain the date that you want.

For example: MonthStart(MakeDate("here obtain the value of the selection*")

* You can use, max(year), min(year), getfieldselections(year), only(year)

MonthStart return a date with the first day of the month, and makedate generates a date with the values that you specified for the year, month and day for example MakeDate (2013,12,08) -- Year, Month, Day

Regards.

Re: Using a trigger to get a Min(CalendarDate)

chiru_thota — Sat, 01 Mar 2014 02:33:13 GMT

It should work for sure.Have you tried any other trigger in the same applications ?

Re: Using a trigger to get a Min(CalendarDate)

paul_scotchford — Sat, 01 Mar 2014 02:41:51 GMT

Thanks Chiranjeevi,

This is how I Implemented it as detailed in my question, it does not work unfortunately, hence my post

cheers

Re: Using a trigger to get a Min(CalendarDate)

maxgro — Sat, 01 Mar 2014 08:13:23 GMT

see attachment

the trigger on select of field year is set variable with expression

=date(min(CalendarDate), 'DD MMM YYYY')

if you want to set the variable also when you select in different calendar fields (date field, ....), use the on select trigger

Re: Using a trigger to get a Min(CalendarDate)

hic — Sat, 01 Mar 2014 10:12:42 GMT

You don't need a trigger for this. Just set the variable to '=Min(CalendarDate)' including the equal sign, and then it will recalculate automatically every time you make a selection.

HIC

Re: Using a trigger to get a Min(CalendarDate)

paul_scotchford — Sat, 01 Mar 2014 11:40:34 GMT

Thanks Henric, that makes sense when I think about it, I will test this on Monday when I'm back in the office .