Find solution for sorting the dimension with expression and assigning row number

[Cherry1098]

Hi,

I did sorting by expression in normal qliksense table, giving row numbers.

In the below screenshot you can see, the sorting by row numbers,

In dimension, the field name is materials.

You can see ,we bifurcations of plastic, metal, glass.

I sorted all plastic breakdown by giving row number as same(assigned as 1),

Then all metal breakdown by giving one more row number as same(assigned as 10)

Then all glass breakdown by giving one more row number as same (assigned as 14 to all)

Then one single rubber material is there, given as 17.

Again the sorting is done among plastic,then among metal, then among glass as per weight of there.

But from the screenshot , sorting went well, but one of the plastic is coming in bottom(assign same as other plastic breakdown material).

I want that polyvinyle acetate to club intlo plastic.

Can anyone help me out in sorting as per my inputs 

[daturpin]

Hard to tell, but does it matter that the PVAC is spelled wrong? Are you sorting on the string "Polyvinyl"?

Also perhaps a nitpik, but PVAC is not a plastic per se, it's a glue...  Probably not helpful but I can't see how you are sorting things in the code.