topic Re: order by sub sum in QlikView

order by sub sum

Thu, 11 Oct 2012 14:11:16 GMT

Hi!

sorry my english...

is anybody know how order table by sub sum?

(in attached files)

Re: order by sub sum

thomas_skariah — Fri, 12 Oct 2012 01:54:47 GMT

Hi,

You can use sort properties->properties->sort->then with first dimension sort by y-value ascending.

Hope this works.

Regards,

Tom

Re: order by sub sum

Mon, 15 Oct 2012 07:40:49 GMT

Tom, thank you fo help. unfortunatly it still not working. may be need to create some formula in this field?

some kind of sort by formula with total

Re: order by sub sum

thomas_skariah — Mon, 15 Oct 2012 08:55:37 GMT

Hi,

Is this oder by column from the image attached on your first post is a calculated expression or a total?

Regards,

Tom

Re: order by sub sum

Mon, 15 Oct 2012 09:08:44 GMT

In image this is column with total sum. this total sum is switch on by

this column appear when i mark on (see above image). this sum in column because i moved field in pivot.

Re: order by sub sum

Tue, 16 Oct 2012 08:53:13 GMT

i mean how i can sort by column "Show Partial Sums"

Re: order by sub sum

thomas_skariah — Tue, 16 Oct 2012 08:57:23 GMT

Hi,

If Possible can you prepare a sample application and forward.

Regards,

Tom

Re: order by sub sum

Tue, 16 Oct 2012 09:57:32 GMT

Hi!

I make a sample. I need just order tabler by value of the last column.

It must be easy, but i dont get it

Re: order by sub sum

thomas_skariah — Tue, 16 Oct 2012 10:19:42 GMT

Hi,

Find the attached application.

Regards,

Tom

Re: order by sub sum

Tue, 16 Oct 2012 12:29:26 GMT

Tom, thank you!

Could you take a look on little sample whith count function?

I need the same thing - order by last column.

thank you for help!

Re: order by sub sum

Tue, 16 Oct 2012 13:07:12 GMT

Thank you very much Tom!!!!

it is working perfecty!!!