topic Sorting Null Values in a Chart in QlikView

Sorting Null Values in a Chart

Wed, 06 Nov 2013 20:14:58 GMT

See the attached document for an example.

In my example I have a chart where the first dimension is null in one case. When sorting by Dim1 the values sort in alphabetical order, but the null value is always at the bottom.

Is there a way I can get rows that have a null Dim1 to sort to the top on a certain order? It needs to be one of ascending or descending, but which one doesn't matter.

Thanks!

Re: Sorting Null Values in a Chart

Anonymous — Wed, 06 Nov 2013 20:29:22 GMT

Ken,

You can replace null with something else. For example, use calculated dimension instead of Dim1

if(isnull(Dim1), 'null', Dim1)

Regards,

Michael

Re: Sorting Null Values in a Chart

Wed, 06 Nov 2013 20:35:10 GMT

This seems to work perfectly. Not sure why I didn't come up with that! Thanks!