topic Re: Expression in Visual Cue in QlikView

Expression in Visual Cue

davyqliks — Sat, 16 Nov 2024 00:35:44 GMT

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

Re: Expression in Visual Cue

chrismarlow — Wed, 27 May 2020 19:14:00 GMT

Hi,

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

Cheers,

Chris.

Re: Expression in Visual Cue

davyqliks — Thu, 28 May 2020 08:05:21 GMT

Thanks so much Chris,

I will give this a go and feedback.

Daniel

Re: Expression in Visual Cue

davyqliks — Thu, 28 May 2020 09:05:08 GMT

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

)

)
)

Re: Expression in Visual Cue

davyqliks — Mon, 01 Jun 2020 16:06:50 GMT

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

Re: Expression in Visual Cue

chrismarlow — Mon, 01 Jun 2020 19:22:13 GMT

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-expressions-outside/m-p/1706249#M48324

Cheers,

Chris.