topic Multi box - is it possible to sort using an expression in QlikView

Multi box - is it possible to sort using an expression

Wed, 04 Nov 2009 16:42:04 GMT

Hi Guys,

I have an expression as one of the fields in a multibox - the issue is that this isn't visible in the sort tab (or font,number,presentation come to that) .

My query is as follows: is it possible to sort using an expression?.

The expression is a month number that i've converted to month name using the following

month('01/' & monthorder & '/00')

I'm in version 8.5

Many thanks

Multi box - is it possible to sort using an expression

amars — Wed, 04 Nov 2009 19:49:42 GMT

Hi Greeny,

You couldn't , you will need to create another dimension in ur script with the formula & will need to use it.

Like join (Tablename) Load month('01/' & monthorder & '/00') as monthName, monthorder Resident TableName;

& then use MonthName or whatever name u use in multibox.

Regards

Amar

Multi box - is it possible to sort using an expression

Wed, 04 Nov 2009 21:35:12 GMT

thought as much - thats what i did - just seems a bit of a backward way of doing it!

Thanks for the reponse