Sorting problem in Qlik Sense

Tue, 02 Dec 2014 09:13:58 GMT

The code below extracts position 3 to 7 from a date (i.e. it returns 14-12 from the date 2014-12-02).

left(right(date(DATE_COLUMN),8),5)

When sorting, the result is mixed up and regardless of if I sort numerically or alphabetically it doesn't work (picture).

The thing is also that the same code was used in Qlik View and the sorting worked well there.

Any one has an idea?

Re: Sorting problem in Qlik Sense

Tue, 02 Dec 2014 09:49:16 GMT

Hi Marcus,

think you might have posted this in the wrong place, might want to repost in the Qlik sense area