Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner
Partner

Help in sortable Aggr

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...

I can walk on water when it freezes
12 Replies
Frank_Hartmann
Master II
Master II

which QV Version are you using?

The sortable Aggr function is finally here!

ali_hijazi
Partner
Partner
Author

I'm using qlikview 12

I can walk on water when it freezes
Anil_Babu_Samineni

Is this you are expecting on your chart?

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ali_hijazi
Partner
Partner
Author

check attached document and help please

I can walk on water when it freezes
sunny_talwar

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

Capture.PNG

Anil_Babu_Samineni

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.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ali_hijazi
Partner
Partner
Author

the cumulative amount is not working properly

see in the screen shot and the document attached

the cumulative amount should start with 82.5

I can walk on water when it freezes
ali_hijazi
Partner
Partner
Author

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

I can walk on water when it freezes
sunny_talwar

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

Capture.PNG

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