Qliksense Pivot table sorting issue

[arvind_patil]

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

[Chanty4u]

Did you tried this?

Pivot Table Sorting - Qlik sense

[arvind_patil]

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]

Nice   is your issue resolved ?  please close the thread

[arvind_patil]

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]

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