topic Re: Sort Expression % in QlikView

Sort Expression %

pgalvezt — Fri, 09 Nov 2012 20:58:08 GMT

Hi, I`ve tried of sort this expression:

in Sort Tab .. Expression.. Descendent

This is my expression but doesn't work

=If(Column(3)= -1,'qmem://<bundled>/BuiltIn/minus.png',Column(2)/Column(1)-1)

I Attached a picture of the expression in % (Var)

Thank you!

whiteline — Sat, 10 Nov 2012 08:09:59 GMT

Hi.

Are you trying to sort by picture ?

Try to write a sorting expression that returns values without using the Column() function.

pgalvezt — Mon, 12 Nov 2012 12:30:36 GMT

Hi, WhiteLine thank you for your reply.

Could you please put an example. I don't understand what do you mean sort by picture.

Thank you!

whiteline — Mon, 12 Nov 2012 13:04:30 GMT

This is your sort expression:

=If(Column(3)= -1,'qmem://<bundled>/BuiltIn/minus.png',Column(2)/Column(1)-1)

It returns picture if column(3)=-1. So here you're trying to sort by picture.

I suggest you to write an expression that returns numbers and also don't use the column() function.