topic Re: Help in sortable Aggr in QlikView

Help in sortable Aggr

ali_hijazi — Tue, 02 May 2017 09:33:54 GMT

Hello got a pivot table showing the open amount for each customer

and in another column I want to show the cumulative amount

the cumulative amount I'm using Aggr with sorting but it is not working properly

check attached document and advise please

as the cumulative amount should start with 82.5 and so on...

Re: Help in sortable Aggr

Frank_Hartmann — Tue, 02 May 2017 09:49:35 GMT

which QV Version are you using?

The sortable Aggr function is finally here!

Re: Help in sortable Aggr

ali_hijazi — Tue, 02 May 2017 10:06:07 GMT

I'm using qlikview 12

Re: Help in sortable Aggr

Anil_Babu_Samineni — Tue, 02 May 2017 10:17:25 GMT

Is this you are expecting on your chart?

Re: Help in sortable Aggr

ali_hijazi — Tue, 02 May 2017 10:37:59 GMT

check attached document and help please

Re: Help in sortable Aggr

sunny_talwar — Tue, 02 May 2017 11:01:52 GMT

I'm using Aggr with sorting but it is not working properly

You have neither explained what isn't working in your post, nor have you mentioned anything in the attached qvw. What is not working properly? You need to point it out, else we will just be doing a lot of guess work

Re: Help in sortable Aggr

Anil_Babu_Samineni — Tue, 02 May 2017 11:55:24 GMT

I've checked and i gave some inputs. Are you looking for that? Or you may need to show where it is not working as sunny suggested.

Re: Help in sortable Aggr

ali_hijazi — Tue, 02 May 2017 12:52:39 GMT

the cumulative amount is not working properly

see in the screen shot and the document attached

the cumulative amount should start with 82.5

Re: Help in sortable Aggr

ali_hijazi — Tue, 02 May 2017 14:40:51 GMT

the cumulative amt should start witn 82.5

so there is something wrong in the Aggr function's structure parameter that I'm supplying

Please advise

Re: Help in sortable Aggr

sunny_talwar — Tue, 02 May 2017 14:45:45 GMT

Since you are sorting by accounting_document_number, here is the sort order

17000010 is 1 followed by 17000011 followed by 17000198 and so on...

Re: Help in sortable Aggr

ali_hijazi — Tue, 02 May 2017 14:51:08 GMT

if I sort by invoice date then documents with the same date will have zero as cumulative amount

please advise

Re: Help in sortable Aggr

ali_hijazi — Tue, 02 May 2017 14:53:38 GMT

how can I sort first by date and then by doc number in the structured parameters?

Re: Help in sortable Aggr

sunny_talwar — Tue, 02 May 2017 14:54:47 GMT

May be create a new field in the script using the combination of Invoice Date and Doc No. Something like this

Floor([Due Date]) + [Doc No.]/1E10 as NewField

and then use NewField in your Aggr() function