Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Anyone know how Qlikview considers characters like " and - when Sorting a field A --->Z.
In this example I am having trouble figuring out why 1.5"STD is above 1.25-7 HEX.
It seems to be a bug of some versions, have tried into 11.00SR1 and sorts ok
I've checked with another version of 11.20 SR3 (32 bit) and did get some different results from my findings yesterday evening and even from yours (numeric sort works at my site also for the Text field...).
I need to correct myself, sort by Numeric Value doesn't work in 11.20, but the SortOrder sort order seems to be correct even without using the latest modifications.
Clever Anjos, I think your sample misses the case
1.5"Something
Which should be preceded by 1.25-7
I´ve found a small trick to fix this issue
Instead of using the field into listbox, I´ve used a field & ' ' concatenation.
It seems to fix it
PFA the qvw
I know this thread is three years old, but in case someone find it by using the search (it's ranked quite high)
I think this works as expected:
Thanks for going back to post this solution Stefan!