Discussion Board for collaboration related to QlikView App Development.
I have to achive below expression for one of the report. Please refer to the attached QVW.
I put this together in the #1,2,3 order of precedence that you outlined. Let me know if all conditions are met accurately
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())
Thanks a lot for help . I am still checking. I will implement to my actual requirement and let you know.