topic Re: sort order in pivot table in QlikView

sort order in pivot table

Mon, 30 Jul 2012 09:39:48 GMT

Hi,

How to sort the data as -3, +3, -8, +8 in this format in pivot table.

In my app calculated dimesion is as follows : =if(Lens#=1,'-3',if(Lens#=2,'+3',if(Lens#=3,'-8','+8')))

Thanks in advance.

Regards,

Venkat

Mon, 30 Jul 2012 09:43:36 GMT

Hey,

You can sort by an expression.

Try sorting it by Lens#

gr.

Frank

Mon, 30 Jul 2012 09:49:41 GMT

hi, thanks for reply.

I tried but it is not getting correct order.

Thanks & Regards,

Venkat

Mon, 30 Jul 2012 09:51:32 GMT

Could you upload an example file?

Mon, 30 Jul 2012 10:52:54 GMT

try this out in the sort settings by expression:

if(Lens#<0, Lens# * -1, Lens#)

It should solve your problem

regards,

Wed, 10 Oct 2012 12:13:13 GMT

Hi kbs,

Could u please explain ur Expression?

if(Lens#<0, Lens# * -1, Lens#)

Because It is fine with sorting, I don't know how it works?

Please explain me.

Thanks in advance..

Regards,

Kabilan K.