topic Re: MAX YEAR in QlikView

MAX YEAR

gauthamchilled — Wed, 25 Nov 2020 16:16:04 GMT

i have a listbox..

Year

FY2015

MY2015

FY2014

MY2014

I WANT TO CREATE A TRIGGER TO SELECT LATEST OR MAX FIELD FROM THIS LISTBOX..

HOW CAN I CREATE AN EXPRESSION FOR SELECT IN FIELD TRIGGER TO SELECT MAX YEAR

Re: MAX YEAR

Chanty4u — Thu, 24 Mar 2016 09:38:36 GMT

try this

Sum({$<Year={'2015'}>}[Sales Amount]) - expression works,

(Year={$(=Max(Year))})

Re: MAX YEAR

Chanty4u — Thu, 24 Mar 2016 09:42:07 GMT

or u can give trigger

select infied

Filedname: date field name

String : =Max(date field)

Re: MAX YEAR

Chanty4u — Thu, 24 Mar 2016 09:43:31 GMT

PFA

sample

Re: MAX YEAR

tresB — Thu, 24 Mar 2016 09:48:12 GMT

What are FY and MY stand for? Which is max year in your sample data?

Re: MAX YEAR

settu_periasamy — Thu, 24 Mar 2016 09:49:22 GMT

Hi,

In the Trigger (May be Button Action / Text Action), Try this..

Select In Field

Field : Year

Search String : ='*'&Max(Aggr(Right(Year,4),Year))

Edit

Instead of '*', Just give 'FY'

='FY'&Max(Aggr(Right(Year,4),Year))

Re: MAX YEAR

gauthamchilled — Thu, 24 Mar 2016 09:52:47 GMT

NONE OF THE SOLUTION WORKED. ATTACHED MY REQUIREMENT.. HELP PLZ

Re: MAX YEAR

gauthamchilled — Thu, 24 Mar 2016 09:53:24 GMT

fy IS FULL YEAR

MY IS MID YEAR

Re: MAX YEAR

settu_periasamy — Thu, 24 Mar 2016 09:56:37 GMT

Have you checked my attachment? If you need When the document open..

find the attachment

Re: MAX YEAR

Kushal_Chawda — Thu, 24 Mar 2016 10:00:31 GMT

see this

check the OnOpen trigger

Re: MAX YEAR

Chanty4u — Thu, 24 Mar 2016 10:01:50 GMT

I think text is not taking as a Year field

we need give text before the exprssion ?

Re: MAX YEAR

martinpohl — Thu, 24 Mar 2016 10:04:11 GMT

see attached file.

Change the trigger from button to docuement properties / triggers.

But remeber:

OnOpen

Select this event to assign an action to be executed each time the QlikView document is opened. This event is not supported when running in the AJAX client.

find here:

Document Properties: Triggers ‒ QlikView

Regards

Re: MAX YEAR

gauthamchilled — Thu, 24 Mar 2016 10:05:16 GMT

YOUR SOLUTION ALWAYS PICKS fy NOT MY..IS IT?

Re: MAX YEAR

gauthamchilled — Thu, 24 Mar 2016 10:06:46 GMT

WHAT IF I ADD MY2016..STILL IT TAKE MY2016 AS MAX?

Re: MAX YEAR

settu_periasamy — Thu, 24 Mar 2016 10:07:56 GMT

You should give '*'

='*'&Max(Right(Year,4))

Re: MAX YEAR

tresB — Thu, 24 Mar 2016 10:12:56 GMT

Check this :

=If( Index(Concat({<Year={'*$(vMaxYear)'}>}Year), 'FY'), '*FY'&vMaxYear, '*MY'&vMaxYear)

Though I believe there would be an easier expression which is not just striking in.

Re: MAX YEAR

Kushal_Chawda — Thu, 24 Mar 2016 10:19:45 GMT

see this, create 3 Variables

now check the OnOpen trigger

Re: MAX YEAR

Kushal_Chawda — Thu, 24 Mar 2016 10:24:21 GMT

Yeah settu, you are correct, but what if FY and MY both have 2015, in this case it will select FY and MY 2015, but what he wants is FY 2015

Re: MAX YEAR

settu_periasamy — Thu, 24 Mar 2016 10:34:18 GMT

Ok Kush141087. I'm getting bit confused.

🙂

Re: MAX YEAR

Kushal_Chawda — Thu, 24 Mar 2016 11:11:27 GMT

settu_periasamy‌

IF you have FY2015 & MY2015 (considering 2015 is max) both in Year field, then by using what you have suggested both FY2015 & MY2015 will be selected on opening application. I think what he wants is only FY2015 should be selected