topic Re: Sort on column which contains images in QlikView

Sort on column which contains images

Fri, 15 Feb 2013 13:22:04 GMT

See below example of the pivot table. I wan't to sort on column 'Movement'. When I click on the red arrow of year '2012', crop 'Tomato' I want to see only the records of Tomato and Corn Salad. How do I realise this? Ditto for the other arrows or '-'.

Crop	Forecast Year To Date	Invoiced	To go	Realised%	Movement	Crop
	Year 2012					Year 2013 (ditto 2012)
Tomato	1.500	0	1.500	0%
Cumumber	2.000	2.000	0	100%
Onion	900	1.400	- 500	155%
Spinach	0	300	-	-	-
Corn Salad	1.600	200	1.400	12,5 %

Content of properties column 'Movement', tab Expressions, Definition:

If(Realised% = '-', '-',
If(Realised% < 0.95,'qmem://<bundled>/BuiltIn/arrow_s_r.png',
If(Realised% < 1.00,'qmem://<bundled>/BuiltIn/arrow_e.png',

If(Realised% = 1.00,'qmem://<bundled>/BuiltIn/arrow_ne_y.png',
'qmem://<bundled>/BuiltIn/arrow_n_g.png'))))

(Grey arrow not shown as example in the table)

Re: Sort on column which contains images

Fri, 15 Feb 2013 13:49:21 GMT

Hi,

I would say you need "Movement" to be a Dimension if you want to achieve this...

Alternatively, you could also create buttons with the logos out of the chart that selects the right %Realised data somehow.

Re: Sort on column which contains images

Tue, 19 Feb 2013 10:19:15 GMT

Thanks for your quick reply. Field 'Movement' as a dimension doesn't solve my problem. I'm trying to make buttons for the sorting, but It looks like this only works with dimension fields. Is this right of are there other possiblities?