Sort By AlphaNumeric in Pivot Table

[azucna122]

Hello, I am new to Qlik, I have a pivot table with this structure:

Dimensions:

- CLUSTER

- SUBGROUP

- CATEGORY_SUBGROUP

- SUBCATEGORY

Column

- ENTITY

Extent

sum(IMP_TOTAL)

What I want is to order the SUBCATEGORY field by the COD_CATEGORIA field (2.A.1.01), which is alphanumeric 

pivoting example

Client No.

  Client number with requirements

- with Client

    2.A.1.04

- archive

    2.A.1.03

- alerts

    2.A.1.02

- No clients

    2.A.1.01

Can you help me organize it correctly? I was using the expression AGGR(DUAL(COD_CATEGORY),GROUP,SUBGROUP,CATEGORY_SUBGROUP,SUBCATEGORY), but it is not working:

Client No.

  Client number with requirements

- No clients

- alerts

- archive

- with clients

[Or]

Dual() created a dual type - one numeric value and one text value. As both of your values are not numeric, this won't work.

You can use Custom Sort - By Expression - and then use an expression along the lines of Only(COD_CATEGORIA)

[azucna122]

Thanks for answering, I had already tried to put the sorting by the field alone COD_CATEGORIA and it doesn't work either....