Expression not working when selecting variables

suvechha_b — Tue, 08 Sep 2015 09:38:37 GMT

set vPhase =

'Design (Plan)',

'Strategy (Assement)',

'Transition (Build Deploy)',

'Operation (Pending Closure)',

'On Hold';

I tried to write it in script of qlikview.

I need the vPhase value in my expression :

eg,

Date(Max({<Type = {MME},Phases = {$(vPhase)}>}Date([Exp End Date])))-Date(Min({<Type ={MME},Phases = {$(vPhase)}>}Date([Start Date])))

But vPhase is picking null when there is selection in the phase.

Model attached.

Output required.

Re: Expression not working when selecting variables

PrashantSangle — Tue, 08 Sep 2015 09:44:11 GMT

Hi,

use =

Date(Max({<Type = {MME},Phases = {'$(=vPhase)'}>}Date([Exp End Date])))-Date(Min({<Type ={MME},Phases = {'$(=vPhase)'}>}Date([Start Date])))

Regards