Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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