Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression review

1. SCAR open in particular month (MTH):

-  InitiationDate <= MTH  AND

-  [ InvestDue <> NULL  AND   ( InvestComplete  = NULL  OR  InvestComplete >= MTH )  OR

-  ( same for ImplementationDate ) ]

to know the timelines as intime....

2. SCAR late in particular month (MTH):

-  SCAR open (see above)  AND

- [ InvestDue <> NULL  AND   InvestDue <= MTH  AND  ( InvestComplete > InvestDue  OR  Today() > InvestDue )  OR

( same for ImplementationDate

to know the timeliness as past due...

Need the expression for this scenario..

Labels (1)
0 Replies