Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
davyqliks
Specialist
Specialist

Expression in Visual Cue

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

Labels (2)
1 Solution

Accepted Solutions
chrismarlow
Specialist II
Specialist II

Hi,

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

20200527_1.png

Cheers,

Chris.

 

View solution in original post

5 Replies
chrismarlow
Specialist II
Specialist II

Hi,

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

20200527_1.png

Cheers,

Chris.

 

davyqliks
Specialist
Specialist
Author

Thanks so much Chris,

I will give this a go and feedback.

Daniel

 

davyqliks
Specialist
Specialist
Author

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
Specialist
Specialist
Author

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
Specialist II
Specialist II

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.