Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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