topic Set analysis and straight table in QlikView

Set analysis and straight table

Tue, 24 Jan 2012 13:40:29 GMT

Hello,

I've got a problem for showing the name of the first next phase reference of a project in a straight table (found with the min of the phase decision start date). I've made a set analysis expression :

=Only({<PhaseDecisionStartDate] = {"$(= min( {< PhaseDecisionOrder = {"1"}>} PhaseDecisionStartDate))"}

>} PhaseReference)

It works but only for the first next phase decision start date of all the projects, and not for each line of the straight table, as shown in the example :

Project Code Phase Reference Phase Reference (expected) Phase Decision Start Date

Project 1 - Phase II 30/12/2015

Project 3 - Phase IV 20/01/2015

Project 4 Phase III Phase III 27/06/2014

Any idea on what must be added in the expression so that it takes into account only the project of the line and not all projects of the selection ?

Thanks !

Thierry

Set analysis and straight table

lironbaram — Tue, 24 Jan 2012 13:52:03 GMT

hei assumig that in every projejct you have PhaseDesiconOrder that have the value 1

then try only({< PhaseDecisionOrder = {"1"}>} PhaseDecisionStartDate)

Set analysis and straight table

CELAMBARASAN — Tue, 24 Jan 2012 13:53:16 GMT

Hi,

Use PhaseDecisionOrder = {"1"} also in Only() function and check whether Min returns the date format same as PhaseDecisionStartDate.

Celambarasan

Set analysis and straight table

Tue, 24 Jan 2012 14:07:59 GMT

No, the problem is not solved with :

=Only({<PhaseDecisionOrder = {"1"},

PhaseDecisionStartDate] = {"$(= min( {< PhaseDecisionOrder = {"1"}>} PhaseDecisionStartDate))"}

>} PhaseReference)

For one project, I havemany phases, some of them have PhaseDecisionOrder = 1 and I want toconsider only these ones. But even with this filter, I still havemultiple phases with different PhaseDecisionStartDate, and I want toget the PhaseReference of the first PhaseDecisionStartDate.

Inmy example, il I make a selection on Project 1, then the expected valueof Phase Reference appears. If I make a selection on Project 1 andProject 3, I get the expected value of Phase Reference only for Project3 (which has the first PhaseDecisionStartDate of the two projects20/01/2015 vs 30/12/2015).

Set analysis and straight table

lironbaram — Tue, 24 Jan 2012 14:38:22 GMT

may be you can trysomthing in the lines of

=firstsortedvalue({<PhaseDecisionOrder = {"1"}>}

PhaseReference,PhaseDecisionStartDate)

Set analysis and straight table

CELAMBARASAN — Tue, 24 Jan 2012 14:42:04 GMT

Try this..

=Only({<PhaseDecisionOrder = {"1"},

PhaseDecisionStartDate] = {"$(=chr(39) & min( {< PhaseDecisionOrder = {"1"}>} PhaseDecisionStartDate) & chr(39))}"}

>} PhaseReference)

Set analysis and straight table

Tue, 24 Jan 2012 14:58:01 GMT

Thanks to you two for your help !