fix (hold) the row order, in a pivot table

[becki_kain]

I have this load script so that my vehicles are displayed in a set order and this works fine, until someone click on a Segment, then the segment which was clicked on goes to the bottom of the table.  if I remove this part of the load script, the rows do not change, no matter what is clicked on, but the order of rows is based on the raw input.  how do I hold or fix the order of the rows to comply with the load script?

Segments:
LOAD * INLINE
[ Segment, SortOrder
Small B Car, 1
Small C Car, 2
Medium Car, 3
Large Car, 4
Sports, 5

];

the sort for the dimension "Segment" is set only to Expression->ascending->=SortOrder

thank you

Becki Kain

[krishnacbe]

Check the attached, I have disabled the State.

[lorenzoconforti]

It's the way QlikView works. When you select data in a field you are filtering the data set. With set expression you can still refer to the whole data set (which you've done in your expression) to extract information not any longer available in the default state ($). While you did this in your pivot table expression, you didn't do it in the expression used for sorting

Read this document, it's really good: Set Analysis: syntaxes, examples

[becki_kain]

and I thought assembler was confusing!  thanks!  this is week 3, end of, of my qlik/excel/alteryx lessons

-becki