Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help needed on Expression

Hi All,

I have to achive below expression for one of the report. Please refer to the attached QVW.

  1. If Id = 1, show the Date1 with Green background where Types exist.
  2. If there is no Types existed for City, show as 'NO'
  3. If Status='Status1' then show 'YES' else show Date1 (If Date1 <= Today() date show with Yellow background else with Green background).

Thanks.

2 Replies
JonnyPoole
Employee
Employee

I put this together in the #1,2,3 order of precedence that you outlined. Let me know if all conditions are met accurately

Status expression:

=IF(Id=1,Date(Date1),

  if( count ( distinct Types)>=1, if (Status='Status1', 'YES', Date1),'NO'

  )

)

Status Background Color formula:

if( Id=1 , LightGreen(),

  if( count ( distinct Types)>=1,

  if (Status='Status1', yellow(),

  if( Date1<Today(), yellow(),LightGreen())

  )

  )

)

Capture.PNG.png

Not applicable
Author

Hi Jonathan,

Thanks a lot for help . I am still checking. I will implement to my actual requirement and let you know.

Thanks again.