topic Help needed on Expression in QlikView

Help needed on Expression

Wed, 01 Oct 2014 15:16:19 GMT

Hi All,

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

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

Thanks.

JonnyPoole — Wed, 01 Oct 2014 15:57:39 GMT

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())

)

Wed, 01 Oct 2014 16:23:26 GMT

Hi Jonathan,

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

Thanks again.