Expression in Visual Cue

[davyqliks]

Hi All,

I have set visual cues to a set expression using the  >=  normal and <=limits 

The visual cues are set to dates so in the Expression 'Last Order Date UK'  I have the following:

Upper >=today()-90 Black

Normal Orange

Lower <=today()-180 Red

This is all working well, but i want to add the same cues to highlight in colour to certain other expressions in the list.

so in the expression for a stock count for instance, i want to highlight the cell based on the other expression.

I have tried these, but they do nothing. 

Only([Last Order Date UK])=today()-90
and
=[Last Order Date UK]=today()-90
There is no expression error but the colouring does not occur.

Does anyone have any idea how to set a visual cue for an expression, based on another expression?

Thank you so much in advance.

Daniel

[chrismarlow · Accepted solution]

Hi,

You can add a formula through the expressions tab to the Text Color of the expression, so something like;

Cheers,

Chris.

[davyqliks]

Thanks so much Chris,

I will give this a go and feedback.

Daniel

[davyqliks]

Hi,

Just wanted to sy thanks again, your example has led me to the required solution of;

<90 Black

>90 Orange

>180 Red

if(Today()-90<= Only( [Last Order Date UK]),
RGB(0,0,0),

if(Today()-180>= Only( [Last Order Date UK]),
rgb(255,26,26),

if(Today()-90>= Only( [Last Order Date UK]),
rgb(250,131,26),

)

)
)

[davyqliks]

Hi Again Chris,

I dont suppose you know how i can select in field a button to only show ALL data with [Last Order Date] >-90 days?

I am looking to only export to excel those dates coloured.

Can you filter on colour? i didnt think  possible so my thinking was to make a button to select the data that is coloured by Expression (text colour).

I have tried select in field and Search string -=date(Today())-180>= but am getting no return.

Any help on this would be much appreciated.

Thanks again

Daniel

[chrismarlow]

Hi,

If you want a permanent selection on the table, or at least on a copy of the table for that export you could use an extra column & dimension limit - sort of like I did here;

https://community.qlik.com/t5/QlikView-Creating-Analytics/Expressions-within-set-analysis-and-use-of... 

Cheers,

Chris.