Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression conditional x-out

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.

4 Replies
Not applicable
Author

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.

Not applicable
Author

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!

Not applicable
Author

What I mean...

Not applicable
Author

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