Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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