topic Highlight expression within a range of criteria in QlikView

Highlight expression within a range of criteria

triciagdaly — Fri, 02 Jan 2015 18:57:26 GMT

I am needing to highlight an expression that's already sorted, and wanting the least 10 and greatest 10 values highlighted. Attached is the expression definition, and a screen snippet. Any help is greatly appreciated!

Thanks!

Re: Highlight expression within a range of criteria

maxgro — Fri, 02 Jan 2015 19:25:29 GMT

maybe with rank?

see attachment

Re: Highlight expression within a range of criteria

triciagdaly — Fri, 02 Jan 2015 20:35:11 GMT

I will need an explanation to this example, with emphasis on understanding why there are duplicate expressions, along with how the rank fields appeared in the Presentation. You have listed a TransLineID. Is this critical in getting this to work? Having a unique identifier for each row? If yes, maybe using rowno(). Am not able to duplicate your example in my scenario.

Re: Highlight expression within a range of criteria

maxgro — Fri, 02 Jan 2015 21:28:27 GMT

You can disable or remove my first expression

For rank field see image; I used rank(expression) for greatest and rank(- expression) for leatest

Regarding TransLineID, unique identifier: I think there is no need of an unique identifier, see second chart in the attachment (2 dimensions, rowno(total ....))

Re: Highlight expression within a range of criteria

Thu, 16 Jul 2015 09:10:50 GMT

Thanks very helpful.