topic Re: Sort fields with null values in QlikView

Sort fields with null values

Fri, 10 Apr 2015 06:34:27 GMT

I tried to order with a dimension match function . I give you an example :

match ( TEAM, 'Madrid' , 'Barcelona' , 'Sevilla ', ' Oviedo ' )

This put it in -> Sort - Expression

But when one team has "0" placed me in the first position. I want Although the value is null, is it possible to continue to keep the order I put it , any suggestions?

Thank You !!

Re: Sort fields with null values

jagan — Fri, 10 Apr 2015 06:46:17 GMT

Hi,

Try this

match ( TEAM, 'Madrid' , 'Barcelona' , 'Sevilla ', ' Oviedo ', '*' )

Regards,

Jagan.

Re: Sort fields with null values

pokassov — Fri, 10 Apr 2015 06:47:20 GMT

Hello!

if(match ( TEAM, 'Madrid' , 'Barcelona' , 'Sevilla ', ' Oviedo ' )>=1,match ( TEAM, 'Madrid' , 'Barcelona' , 'Sevilla ', ' Oviedo ' ),99)

Re: Sort fields with null values

Joaquin_Lazaro — Fri, 10 Apr 2015 06:56:16 GMT

Hello rrrrrrrr8:

Try this:

If (match( ...) = 0, 99, match( ...)

Saludos,

Joaquín

Re: Sort fields with null values

Mon, 13 Apr 2015 07:46:55 GMT

SOLUTION:

Ordenar dimensión con campos nulos