Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
grajmca_sgp123
Creator
Creator

how to sort text and numeric values in straight table

Hi,

I need to sort one dimension in Straight table which contains both numeric values and text values in a way like numeric values should be starting in the  table followed by text values in the ascending order.

 

grajesh_sgp_1-1695817679731.png

Expected output : 

grajesh_sgp_2-1695817778096.png

Can anyone please help me here.

Labels (1)
  • Chart

1 Reply
Or
MVP
MVP

Simply sort by L1, then by L2. Note that L1 should be classified as numeric.

Or_0-1695819124960.png