Sorting within a Pivot Table with combined field

[kakaderanjit53]

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.

[jayshrinipurte]

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