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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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?

Labels (1)
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.