Even though I do not quite understand, why sorting by "load order" does not work, I managed to display it correctly using a work around:
[Table]: LOAD ID, subfield(Flow, '>') as [Flow State], Rowno() as [load order] INLINE [ ID, Flow 123, 1>2>3>7>3 456, 2>4>5>1>3 ];
1. I then created a "Straight Table" chart
2. Added all three dimensions to it
3. Static expression (=1)
4. Promoted load order in "Sort" tab, and sorted by numeric value
5. In presentation tab hidden expression & "load order"
Final table looks like that:
Hope it helps. App attached.
subfield and sorting.qvw 152.2 K
another possibility to create a sequence number could be:
tabFlowState: LOAD CustomerID, SubField(Flow,'>',IterNo()) as FlowState, IterNo() as FlowSeq Resident tabFlow While IterNo()<=SubStringCount(Flow,'>')+1;
A table box might not be appropriate to present your data because you have repeating flow states while table boxes only show distinct rows. Maybe a straight table could do instead?
hope this helps
QlikCommunity_Thread_233951.qvw 161.2 K