Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kakaderanjit53
Contributor III

Sorting within a Pivot Table with combined field

Hi Qlik Experts,

I have to sort the data based on the Combined field,

I have created created a Combined field  i.e. MagCategoryID_Unique

by concatenating ID+MagCategoryID which are two separate fields,Now I have to sort the Data in Pivot table (Qliksense) based on the' MagCategoryID_Unique ',

how I can do it.

Is there any solution for the same?


thanks and regards,

Ranjit.

Tags (1)
1 Reply
jayshrinipurte
Contributor

Re: Sorting within a Pivot Table with combined field

hi Ranjit,

You Can achieve this by using Expression Sorting on your Concatenated Field

Select Sort by Expression from Sorting and put below expression.

Eg.

Subfield('MagCategoryID_Unique','_',2)

This will sort by MagCategoryID. If you want to sort by Id then replace 2 with 1.

Regards,

Jayshri Nipurte

Community Browser