Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Expression not working when selecting variables

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.

Capture.PNG

Model attached.

Capture.PNG

Output required.Capture.PNG

1 Reply
PrashantSangle

Hi,

use =

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂