Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

Picking Value from 1:N table

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

Applications:   

IRNBugzilla ProductFPFP recalc.
IRN-11947UK-UKS525

Versions:

Kpi MonthBugzilla Product[Kpi PM][Bugzilla Product][Kpi Bugzilla Product Version][Kpi Real MEP date][Kpi FPA Dif]Kpi FPA Fin[Kpi Type of CHANGE]
10/2015UK-UKSMMMUK-UKS5.0_CH12015/08-1048769CH1
06/2015UK-UKSMMMUK-UKS4.0_CH12015/23-0648721CH1
03/2015UK-UKSMMMUK-UKS3.0_CH12015/30-0396625CH1
02/2015UK-UKSMMMUK-UKS2.0_CH12015/03-0248625CH1

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.

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Picking Value from 1:N table

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


talk is cheap, supply exceeds demand
Highlighted
Not applicable

Re: Picking Value from 1:N table

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