topic fx Sorting by expression Field01 & Field02 In QlikSense April 2018 in App Development

fx Sorting by expression Field01 & Field02 In QlikSense April 2018

wdchristensen — Sat, 16 Nov 2024 21:32:30 GMT

Hi Community,

I have tried to sort on 2 fields concatenated together to create a custom sort but it just won't work. As a work around, I have concatenated the fields in the load script which will work sometimes but if you wanted to apply custom sort logic off a selected value or something dynamic that approach won't work. Has anyone got this to work on any version of Qlik Sense?

Re: fx Sorting by expression Field01 & Field02 In QlikSense April 2016

wdchristensen — Thu, 24 Jan 2019 16:36:20 GMT

Sort in excel attached....

Re: fx Sorting by expression Field01 & Field02 In QlikSense April 2016

wdchristensen — Thu, 24 Jan 2019 16:38:11 GMT

Can't upload the QVF....

get the error "The contents of the attachment doesn't match its file type."

Re: fx Sorting by expression Field01 & Field02 In QlikSense April 2016

wdchristensen — Thu, 24 Jan 2019 16:46:23 GMT

Attached example file as a zip since it won't upload a QVF for some strange reason.

Re: fx Sorting by expression Field01 & Field02 In QlikSense April 2016

wdchristensen — Thu, 24 Jan 2019 16:48:07 GMT

Correct the highlighted errors and try again.

The contents of the attachment doesn't match its file type.

Re: fx Sorting by expression Field01 & Field02 In QlikSense April 2018

Fedemar — Fri, 25 Jan 2019 18:40:27 GMT

Hi, could you give an example of the custom or dynamic sorting you would like to do?

Thanks.