4 Replies Latest reply: Feb 15, 2016 4:51 AM by Nathaniel Anderson RSS

    Unexpected sort on a Calculated Dimension: [Line] & ' ' & [Label]

    Nathaniel Anderson

      Please see attached Qlikview.


      Simple Load Script:

      sort load script.PNG

      Simple List Boxes, the third of which doesn't sort how I expect.

      unexpected sort order.PNG


      Now I can think of various confounding factors:

      • The calculated dimension that combines two dimensions: [Line] & ' ' & [Label]
      • The fact that I load the same dataset, and then reload it again


      And so I can workaround and achieve my expected behavior

      • Separate Line and Label dimensions (could use a Chart if needed)


      But I can't wrap my head around why these things (might) cause the unexpected the results.