This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
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()-90and=[Last Order Date UK]=today()-90There 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.
You can add a formula through the expressions tab to the Text Color of the expression, so something like;
View solution in original post
Thanks so much Chris,
I will give this a go and feedback.
Just wanted to sy thanks again, your example has led me to the required solution of;
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),
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.
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;