Sorting in Dimension

[caphanikumar]

Hi, i am new to the Qilk sense. Need help on sorting the data as per the desired order in the same dimension. 

For example:  I have taken one of the column 'Category' as a Dimension.

Category has a data   A,Z,C,E,W,D,F

 i want the data displayed in my pivot table as A,D,E,W,Z,C,F 

[SterreKapteijns]

Hi! You can create a custom sort order in the load script with an inline load. 

learning.qlik.com/pluginfileframe.html?src=https%3A%2F%2Flearning.qlik.com%2Fpluginfile.php%2F192370...

Course: Creating Data During Reload (qlik.com)

[SunilChauhan]

In sort expression use below 

Wildmatch(fieldname,'A','D','E','W','Z','C','F')

And select ascending.

[AnsweringTuring]

To sort the data in a dimension field according to a custom order in Qlik Sense, you can follow these steps:

1. Open the Data Manager and select the table containing the dimension field you want to sort.
2. Click on the dimension field to open the data profiling card.
3. Navigate to the "Order" tab in the data profiling card.
4. In the "Current Order" section, you will see the distinct values from the dimension field listed.
5. Click and drag the values to reorder them in the desired sequence (e.g., A, D, E, W, Z, C, F).
6. The "Preview of order" section will display a bar chart reflecting the new order.
7. Once you have arranged the values in the desired order, the custom sorting will be applied to the dimension field in any visualization that uses it.

This custom ordering overrides the default alphabetical or numeric sorting in Qlik Sense visualizations. If you need to revert to the default sorting, you can reset the order by clicking the "Cancel" button in the "Order" tab.