topic Re: Random Sorting in QlikView

Random Sorting

Tue, 21 Feb 2012 13:31:18 GMT

Dear Community,

again i've got some rather easy looking question which i can't solve.

In a bar chart i want to sort the main dimension "randomly" (e.g.: 2006 2008 2007 2005). How can i use this sorting option?

I tried it with a set analysis, but it doesnt work.

Thanks in advance for any help.

regards

donuteater

Random Sorting

CELAMBARASAN — Tue, 21 Feb 2012 13:35:45 GMT

Hi,

Try with this expression in sort by expression option.

=match(YearField,'2006','2008','2007','2005')

Celambarasan

Re: Random Sorting

Tue, 21 Feb 2012 14:12:39 GMT

// solved

This formular works pretty well, but still i've got a problem with some of my calculations.

in some Diagrams with a YearEndEstimate-formula the Dimension is sorted totally weird.

I get results like 'Mae','Jan','Aug'

although i applied the proper sorting via the match() formular.

What does the match formula do?

problem was caused by different naming of columns (Mae <> Mrz)

Thanks for you profund help! 🙂

Re: Random Sorting

rbecher — Tue, 21 Feb 2012 18:10:15 GMT

The match function performs a case sensitive comparison and returns the found position.

BTW, this is not a random sorting because of the literal years-list. If you need a real random sorting just use the random function as sort expression:

=rand()

- Ralf