Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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')
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')
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"
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