Solved: Custom Visual Cues - Qlik Community

Anonymous · ‎2015-12-08

I have an expression (Latest Date) which shows the latest date per the dimension, DATA TYPE:

Max(Date)

What I want to do is change the color of the text of the expression to RED if the [Latest Date] of the specific data set is < Max(Date) of the entire QV. Below is what I have in the TEXT COLOR prompt of the expression but it is not working as expected:

=if([Latest Period]< (max(Date)), RGB(255,66,66))

Any help is appreciated!

- dave

effinty2112 · ‎2015-12-08

Hi Han, sorry David,

It's difficult to answer this without knowing where you're putting the expression. If it's a chart what dimensions are used etc.

Try:

=if([Latest Period]< (max(TOTAL Date)), RGB(255,66,66))

View solution in original post

effinty2112 · ‎2015-12-08

Hi Han, sorry David,

It's difficult to answer this without knowing where you're putting the expression. If it's a chart what dimensions are used etc.

Try:

=if([Latest Period]< (max(TOTAL Date)), RGB(255,66,66))

Anonymous · ‎2015-12-08

Andrew - The expression was in a straight table and your solution worked.

Thank you very much!