Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a ranking table which on which I need to conditionally x-out the expression values for the top couple of rows.
Simplified, something like this:
Rank Name Score
1 ABC xxx
2 DEF xxx
3 GHI 10
4 JKL 9
I can set text color to same as background based on rank which affectively blanks out columns but I need xxx look above.
Other idea was to show a hatch pattern in background but it seems I can only set to a solid color.
Any ideas gratefully received..... thanks in advance.
Have you thought about using an if statement that if the rank is >=2, return 'xxx', otherwise return the value? May be something to think about.
PS Now that I think about it, it would be 'xxx' only if the rank were LESS THAN or equal to 2, not greater than. Sorry about that!
What I mean...
Rebecca
Thank you so much. So easy.
I'm new to QV..... (really?) had assumed this would mess my totals up but it doesn't of course.
Many thanks for taking time to post.
Mike Thornton