topic Re: Sorting "empty" value last instead of first in QlikView

Sorting "empty" value last instead of first

TomHolland — Wed, 25 Nov 2020 16:16:04 GMT

I have 3 "values" to sort: "empty", REF and NRF.

I would like value "empty" to come first, REF second and NRF last:

6	70	40
6	70	40	REF
6	7	40	NRF

Qlikview however seems to put "empty" value Always last:

6	70	40	NRF
6	70	40	REF
6	7	40

6	70	40	REF
6	70	40	NRF
6	7	40

How can I solve this?

Re: Sorting "empty" value last instead of first

jyothish8807 — Mon, 10 Dec 2018 06:03:40 GMT

Hi Tom,

Try like this:

If you have a straight chart and the 'Field2' is having this values, then write the below in sort expression.

match({1}Field2,'','REF','NRF')

Re: Sorting "empty" value last instead of first

kjhertz — Mon, 10 Dec 2018 14:30:12 GMT

In the Chart properties Sort tab, try sorting by an expression that gives lower value for nulls for example:

sign(len([REF NRF FieldName]))

And also tick in:

Sort by "Text z-a"

Re: Sorting "empty" value last instead of first

TomHolland — Wed, 19 Dec 2018 20:12:57 GMT

Hi KC,

I tried your suggestion.

At first it did not work.

But I added in loading script:

NULLASVALUE *;
SET NullValue ='';

and than I used your suggestion as follows:

match(Field2,'','REF','NRF')

This way it works the way I wanted!

Thanks,

Tom

Re: Sorting "empty" value last instead of first

TomHolland — Wed, 19 Dec 2018 20:15:54 GMT

Hi Jonas,
I tried your suggestion, but I did not succeed in making it work.

Can be because I'm a beginner and not understanding everything yet.

Thanks for your suggestion.
Tom