Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor III

order numbers

Hi all,

i have chart dimension 

ss;&'-'&custnumber

01

02

03

04

05

now my chart is showing  different order  i want to show  01,02,03,04,05   order how can i do?

sort.PNG

Tags (3)
1 Solution

Accepted Solutions

Re: order numbers

May be try this as your chart dimension

Dual('SS' & '-' & custnumber, custnumber)

3 Replies

Re: order numbers

May be try this as your chart dimension

Dual('SS' & '-' & custnumber, custnumber)

Re: order numbers

Or you can sort by Text A -> Z

soniasweety
Valued Contributor III

Re: order numbers

this worked thank you