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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
rharmsny
Contributor
Contributor

creating a string of sorted variable values

In an action, I'd like to create a list of values from 5 variables into a sorted list.

Example:

var1 = -10

var2 = 0

var3 = -20

var4 = 20

var5= 10

I'd like to load a variable with a list that I can use the "pick" function against in sorted order so the above example would look like this:

varsort = -20, -10, 0, 10, 20

If the values are the same, it doesn't matter which variable gets loaded first

Any ideas?

10 Replies
johnw
Champion III
Champion III


RHARMSNY wrote:I'll petition for a rangesort() function!


I think you'd want a rangeconcat() function. The concat() function supports a sort sequence, which seems to be what you want to do here.