topic Re: Custom Visual Cues in QlikView

Custom Visual Cues

Anonymous — Tue, 08 Dec 2015 17:08:36 GMT

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

Re: Custom Visual Cues

effinty2112 — Tue, 08 Dec 2015 17:19:45 GMT

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

Re: Custom Visual Cues

Anonymous — Tue, 08 Dec 2015 17:29:27 GMT

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

Thank you very much!