Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
arvind_patil
Partner - Specialist III
Partner - Specialist III

Qliksense Pivot table sorting issue

Dear Experts,

I am facing sorting issue in pivot table.

1. I have write formula like  sum (sales) but it is appiled only first dimension.

2 . For second dimesion I also used aggr function as well.

note:- For first field sort order is working but in further drill its not.

Please help me if nay one who knows rather than this.

Thanks,

Arvind Patil

6 Replies
Chanty4u
MVP
MVP

arvind_patil
Partner - Specialist III
Partner - Specialist III
Author

Hi Chanty,

It Helps me but too much calculations

So your first dimension is salesmen.

Your second dimension will be "=AGGR(DUAL([Customer],RowNo(TOTAL)),Salesmen,[Customer])"

The third dimension will look like "=AGGR(DUAL([Number],RowNo(TOTAL)),Salesmen,Customer,[Number])"




It Helps Me

Chanty4u
MVP
MVP

Nice   is your issue resolved ?  please close the thread

arvind_patil
Partner - Specialist III
Partner - Specialist III
Author

Hi Chanty,

It takes  time for calculation or else for small data set its good .

I am looking for any other alternative.

Thanks,

Arvind Patil

Chanty4u
MVP
MVP

marcowedel‌   might help ?

MarcoWedel

please post a sample application containing some data as well as your current pivot table and specify your required result.

thanks

regards

Marco