Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multi box - is it possible to sort using an expression

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

1 Solution

Accepted Solutions
amars
Specialist
Specialist

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

AmarSmile

View solution in original post

2 Replies
amars
Specialist
Specialist

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

AmarSmile

Not applicable
Author

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

Thanks for the reponse