Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
davyqliks
Creator III
Creator III

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.

 

View solution in original post

davyqliks
Creator III
Creator III
Author

Thanks so much Chris,

I will give this a go and feedback.

Daniel

 

davyqliks
Creator III
Creator III
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
Creator III
Creator III
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.