topic If condition ? in QlikView

If condition ?

Fri, 03 Jun 2016 11:03:47 GMT

hi All,

As per the given table , it was in Hierarchical order based on the Dates.

My req is:

1) if it is Having Actual dates till Tarc in SubDiv, So it is in 'First Stage'.

2) for example, if it is Having Actual dates till FPEV in SubDiv & LPIV,KEVT are not Enetred, So it is in 'Second Stage'.

Div	SubDiv	Plan	Actual
Gen	Protocol	18/12/2015	29/12/2015
Gen	Tarc	10/01/2016	03/03/2016
Gen	finalization	12/01/2016	-
Gen	EC	29/02/2016	-
Gen	FPEV	05/03/2016	-
Gen	LPIV	01/09/2016	-
Gen	KEVT	03/09/2016	-

As of now Gen (Div) is 'First Stage' based on the Actual.

Please help me how can i acheive it.

Regards,

Helen

Re: If condition ?

swuehl — Fri, 03 Jun 2016 12:11:05 GMT

Create another field in the script that is linked to SubDiv and describing the stage:

LOAD * INLINE [

SubDiv, Stage

Protocol, First

Tarc, First

finalization, Second

Ec,Second

FPEV, Second

LPIV, Third

KEVT,Third

];

Then create a chart with dimension Div and expression

=FirstSortedValue( {1} Stage, -Actual)

to show the current stage the Div is in.

Note that Actual dates need to have a numeric representation, i.e. they are correctly interpreted as dates (e.g. by setting the correct format code in the script).

Re: If condition ?

Sat, 04 Jun 2016 06:56:16 GMT

Like this we are having Multiple Divs,

For Example, fro the Third stage LPIV Actual should be entered & KEVT Should not be entered

Then it should come Third Stage ...

Can you provide me Some example..

Thanks,

Helen

Re: If condition ?

swuehl — Sat, 04 Jun 2016 09:41:09 GMT

See my sample code above. You can adapt to your requirements (e.g. Assigning KEVT to a different stage) assuming that stage proceed with entered DIVs.