How create a TriggerDoc on the lastDate(Year)?

[#1]

Hi,

I'm new on Qlikview and i'm a little bit stuck... I'm trying to build a trigger on my Document QV. It have to auto-select, when the document is launch, the Field [YearQ] and the last value (So 2014). [YearQ] inclued those values {2012, 2013, 2014}.

I've try

    =Max[[AnnéeQ]]
    =Year(Today())=[AnnéeQ] 

But that didn't work.

Could you help me pliz ?

Thx, in advice  

[its_anandrjs]

Use =Max( [AnnéeQ] ) i think it will works you use wrong brackets.

[ger_alegria]

Try only with max(AnnéeQ). That should works.

[MK_QSL · Accepted solution]

Check enclosed file....

[its_anandrjs]

Use Max() function like

=Max( Yourfieldname )

with brackets

[#6]

Hi Anand and thank you,

No, I've try it. That didn't work.

[its_anandrjs]

What is your year field name

use in trigger like =Max(Youryearfield)

if it is [YearQ]

then use =Max([YearQ])

[#8]

Thank you all,

That's strange cause now that's working.

[#9]

That's exactly what i've done.

But when I try '=Min([Year])' to check if that's work that still auto-select 2014.

But I'm agree your solution works ^^ so i'm fine with this problem.