Picking Value from 1:N table

Wed, 17 Feb 2016 09:26:53 GMT

Hello,
I have problem with my expresion. I have two tables. One with applications and second with versions informations.

Applications:

IRN	Bugzilla Product	FP	FP recalc.
IRN-11947	UK-UKS	525

Versions:

Kpi Month	Bugzilla Product	[Kpi PM]	[Bugzilla Product]	[Kpi Bugzilla Product Version]	[Kpi Real MEP date]	[Kpi FPA Dif]	Kpi FPA Fin	[Kpi Type of CHANGE]
10/2015	UK-UKS	MMM	UK-UKS	5.0_CH1	2015/08-10	48	769	CH1
06/2015	UK-UKS	MMM	UK-UKS	4.0_CH1	2015/23-06	48	721	CH1
03/2015	UK-UKS	MMM	UK-UKS	3.0_CH1	2015/30-03	96	625	CH1
02/2015	UK-UKS	MMM	UK-UKS	2.0_CH1	2015/03-02	48	625	CH1

Now i need show a table of application with value for FP recalc. of nlatest version.
I was eable show latest version by this expresion:
=MaxString({$<[Kpi Bugzilla Product Version]=E({1<[Bugzilla Product]={$(=null())}>}[Kpi Bugzilla Product Version])>}[Kpi Bugzilla Product Version])

But when i was trying to use it for finding FP Recalc value it fails (I even try this: Set Analysis Wizard for QlikView | qlikblog.at😞
=Only({$<[Kpi Bugzilla Product Version]={$(=MaxString({$<[Kpi Bugzilla Product Version]=E({1<[Bugzilla Product]={$(=null())}>}[Kpi Bugzilla Product Version])>}[Kpi Bugzilla Product Version]))}>}[Kpi FPA Fin])

Can somebody help me to solve this?

PS: I have seen in my data that Version 6 f.e. has lover [KPI Real MEP Date] then version 5. Its sound stupid (And it is) but it is like that.

Re: Picking Value from 1:N table

Gysbert_Wassenaar — Wed, 17 Feb 2016 17:07:49 GMT

Try FirstSortedValue( [Kpi FPA Fin], -[Kpi Real MEP date])

Re: Picking Value from 1:N table

Fri, 19 Feb 2016 11:32:07 GMT

Unfortunaly, even if its not in my example (Iam sorry). The [KPI Real MEP Date] is not trust worty in thiss matter.

I have seen in my data that Version 6 f.e. has lover [KPI Real MEP Date] then version 5. I sound stupid (And it is) but it is like that. So this wont will work for me

topic Picking Value from 1:N table in QlikView

Picking Value from 1:N table

Re: Picking Value from 1:N table

Re: Picking Value from 1:N table