topic Re: visual cues in QlikView

visual cues

Thu, 02 Jan 2014 07:43:31 GMT

Hi,

Wondering if its possible, and if so, how to rank results in visual cues.

So we currently have quite a few staright tables that have 31 results (we have 31 neighbourhoods) and was wondeirng if these could be coloured based on position. So for example the first 10 results are green, 11-20 are amber and 21-31 are red. Obviously this has to be done in the script but is this possible?

Any help would be greatly appreciated.

Cheers

Chris

Re: visual cues

Siva_Sankar — Thu, 02 Jan 2014 07:55:37 GMT

If you just want to highlight the fields consistently by value, I think can use something like

=pick(FieldIndex('Item',Item),blue(), green(),yellow(),lightblue(),lightgreen(),lightyellow())

Regards.

siva

Re: visual cues

jvishnuram — Thu, 02 Jan 2014 08:09:27 GMT

Hi Chris,

Is there any intention to use visual cues for your requirement., if not use the text color in expression tab.

Re: visual cues

sujeetsingh — Thu, 02 Jan 2014 08:59:00 GMT

See this sample may it help you

Re: visual cues

Thu, 02 Jan 2014 12:08:43 GMT

Hi,

The value may change depending on field selected but there will always be 31 results (neighbourhood).

sujeetsingh - tried copying expression but didnt seem to work...

Here is the table and data trying to get this to work on. So love the top 10 to be green, 11-20 yellow, 21-31 red.

Neighbourhood	Count(No_Repairs)
	4692
Barton Lane & Trafford Road	567
Eccles & Weaste	326
Mountskip	314
Armitage	312
Clifton Green	312
Peel	260
New Lane	216
Kenyon	213
Brindley	203
Monton & Ellesmere Park	198
Westwood & Alder Park	196
Swinton South	189
Brookhouse & Newland	164
Manchester Road South	159
Moss Vale	151
Baronfold	112
Peel Green	107
Amblecote	89
Walkden South	80
Astley Area	76
The Glaze	72
Pendlebury	64
Grosvenor	61
The Vista	41
Higher Irlam	38
Wardley	36
Falmouth	35
Agecroft	33
Nelson	32
Moorside	22
Boothstown	14

Re: visual cues

Clever_Anjos — Thu, 02 Jan 2014 12:25:50 GMT

Use this expression as BackGroundColor

if (rowno() < 11, lightgreen(), if(rowno()<21, yellow(), lightred()))