topic Re: How create a TriggerDoc on the lastDate(Year)? in QlikView

How create a TriggerDoc on the lastDate(Year)?

Mon, 14 Apr 2014 14:46:02 GMT

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

Re: How create a TriggerDoc on the lastDate(Year)?

its_anandrjs — Mon, 14 Apr 2014 14:51:30 GMT

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

Re: How create a TriggerDoc on the lastDate(Year)?

ger_alegria — Mon, 14 Apr 2014 15:18:33 GMT

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

Re: How create a TriggerDoc on the lastDate(Year)?

MK_QSL — Mon, 14 Apr 2014 15:23:12 GMT

Check enclosed file....

Re: How create a TriggerDoc on the lastDate(Year)?

its_anandrjs — Mon, 14 Apr 2014 15:34:43 GMT

Use Max() function like

=Max( Yourfieldname )

with brackets

Re: How create a TriggerDoc on the lastDate(Year)?

Tue, 15 Apr 2014 07:18:00 GMT

Hi Anand and thank you,

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

Re: How create a TriggerDoc on the lastDate(Year)?

its_anandrjs — Tue, 15 Apr 2014 07:24:13 GMT

What is your year field name

use in trigger like =Max(Youryearfield)

if it is [YearQ]

then use =Max([YearQ])

Re: How create a TriggerDoc on the lastDate(Year)?

Tue, 15 Apr 2014 07:24:14 GMT

Thank you all,

That's strange cause now that's working.

Re: How create a TriggerDoc on the lastDate(Year)?

Tue, 15 Apr 2014 07:37:22 GMT

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.