Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arvind_patil
Valued Contributor II

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

Tags (1)
6 Replies
sureshqv
Esteemed Contributor III

Re: Qliksense Pivot table sorting issue

arvind_patil
Valued Contributor II

Re: Qliksense Pivot table sorting issue

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

sureshqv
Esteemed Contributor III

Re: Qliksense Pivot table sorting issue

Nice   is your issue resolved ?  please close the thread

arvind_patil
Valued Contributor II

Re: Qliksense Pivot table sorting issue

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

sureshqv
Esteemed Contributor III

Re: Qliksense Pivot table sorting issue

marcowedel‌   might help ?

Re: Qliksense Pivot table sorting issue

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

thanks

regards

Marco

Community Browser