Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
use =
Date(Max({<Type = {MME},Phases = {'$(=vPhase)'}>}Date([Exp End Date])))-Date(Min({<Type ={MME},Phases = {'$(=vPhase)'}>}Date([Start Date])))
Regards