Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

If condition ?

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

3 Replies
MVP
MVP

Re: If condition ?

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).

Not applicable

Re: If condition ?

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

MVP
MVP

Re: If condition ?

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.

Community Browser