topic Re: expression conditional x-out in QlikView

expression conditional x-out

Fri, 22 Feb 2013 21:06:01 GMT

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.

Fri, 22 Feb 2013 22:33:43 GMT

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.

Fri, 22 Feb 2013 22:35:42 GMT

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!

Fri, 22 Feb 2013 22:38:48 GMT

What I mean...

Fri, 22 Feb 2013 22:45:06 GMT

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