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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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.