topic Trigger to select latest 3 half yearly in QlikView

Trigger to select latest 3 half yearly

Tue, 13 Oct 2015 06:05:32 GMT

Hi have a requirement to select last 3 values from the list box :

2010HI

2010H2

2011HI

2011H2

2012HI

2012H2

2013HI

2014H2

2015H1

MOSTRECENT SIX MONTH

i want to apply a trigger to capture MOSTRECENT SIX MONTH,2015H1,2014H2? But i cannot hard code as when data refreshes it should capture last 3 values everytime.

Can any one help me on this?

Khushboo

Re: Trigger to select latest 3 half yearly

tresB — Tue, 13 Oct 2015 06:14:30 GMT

Try:

Search string: ='('&Concat({<Field={"=Rank(Dual(Field,Left(Field,4)*10+Right(Field,1)))<4"}>}Field, '|')&')'

PFA

Re: Trigger to select latest 3 half yearly

Tue, 13 Oct 2015 07:10:38 GMT

you forgot that i need to capture MOST RECENT SIX MONTH,2015H1,2014H2.

I need to capture most recent 6 month as well?

Re: Trigger to select latest 3 half yearly

tresB — Tue, 13 Oct 2015 07:14:04 GMT

I.e. only last two quarters, right?

='('&Concat({<Field={"=Rank(Dual(Field,Left(Field,4)*10+Right(Field,1)))<3"}>}Field, '|')&')'

Re: Trigger to select latest 3 half yearly

Tue, 13 Oct 2015 07:19:45 GMT

The data like most recent six month is coming from DB.

so i need to select this string( most recent six month) and 2015H1 and 2014H2.

Last 3 values?

can we use rank on the script side and handle this?

Thanks a ton for your help.

Re: Trigger to select latest 3 half yearly

tresB — Tue, 13 Oct 2015 07:24:57 GMT

Well, is this string 'MOST RECENT SIX MONTHS' is fixed or it may come as 'Most recent 3 months' or so at times?

Re: Trigger to select latest 3 half yearly

Tue, 13 Oct 2015 07:26:09 GMT

This string is fixed .

Re: Trigger to select latest 3 half yearly

tresB — Tue, 13 Oct 2015 07:32:34 GMT

Then try:

='( "MOSTRECENT SIX MONTH" '&Concat({<Field={"=Rank(Dual(Field,Left(Field,4)*10+Right(Field,1)))<3"}>}Field, '|')&')'