topic Re: Sorting Issue in QlikView

Sorting Issue

chhavi376 — Thu, 06 Oct 2016 08:35:29 GMT

Hi,

The requirement is :

I want to show all the values above 1000 as- 1K for 1000, 26K for 26000 etc.

And all values below 1000 as it is.

I am using the following expression:

if(Number>1000,num(Number/1000,'###.0K'),num(Number,'###,##'))

But when i double click on the label to sort, the order is not right.

Can this be done?

sfatoux72 — Thu, 06 Oct 2016 19:58:16 GMT

Yes

use Dual(text,number)

Your expression will be : if(Number>1000,dual(num(Number/1000,'###.0K'),Number),Dual(num(Number,'###,##'),Number))

Regards

sunny_talwar — Thu, 06 Oct 2016 20:00:17 GMT

Or may be this:

Dual(If(Number > 1000, Num(Number/1000, '###.0K'), Num(Number,'###,##')), Number)

chhavi376 — Fri, 07 Oct 2016 05:27:15 GMT

Please check the attached QVW.

The sorting is wrong even after using DUAL.

I have tried both the expressions.

chhavi376 — Fri, 07 Oct 2016 05:28:12 GMT

I have attached the QVW.

Please have a look.

sunny_talwar — Fri, 07 Oct 2016 15:53:53 GMT

Isn't this what you want?

chhavi376 — Wed, 02 Nov 2016 10:12:34 GMT

This works right. (Y)

I figured out another solution as well,

i.e, adding the expression as dimension, and then writing an expression in the 'sort' of the dimension.

Thanks anyway.