Sorting "empty" value last instead of first

[TomHolland]

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

or

6	70	40	REF
6	70	40	NRF
6	7	40

How can I solve this?

[jyothish8807 · Accepted solution]

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')

[kjhertz]

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"

[TomHolland]

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

[TomHolland]

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