Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

Sort Expression %

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!

3 Replies
whiteline
Master II
Master II

Hi.

Are you trying to sort by picture ?

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

pgalvezt
Specialist
Specialist
Author

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
Master II
Master II

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.