Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to sort a field that is a mix of number and text ??

'Q' & Ceil(Month(Start_Month)/3) & '-' & Yearname(Start_Month) as Quarter_IPC

The above is my definition of a variable.

It shows up as:

Q4-1990

Q3-1992

Q1-1995

...

...

...

How can I sort these year wise ? Like

Q1-1990

Q2-1990

Q3-1990

Q4-1990

Q1-1991

..

..

1 Solution

Accepted Solutions
Highlighted

Create a field with Dual

Dual('Q' & Ceil(Month(Start_Month)/3) & '-' & Year(Start_Month), QuarterStart(Start_Month)) as Quarter_IPC

Then Use Sort By Number as ascending

View solution in original post

8 Replies
Highlighted
Not applicable

Hi,

In the list box property, go to Sort tab, tick Expression check box and use the expression as "=Start_Month"

Highlighted
Master II
Master II

try in sort tab expression

dual(Quarter_IPC,Year(Start_Month))

in ascending order

Highlighted
Not applicable

Nope. Its not working.

There is also that red line appearing beneath the text when I enter it in that expression box.

"=Start_Month"

Highlighted

Create a field with Dual

Dual('Q' & Ceil(Month(Start_Month)/3) & '-' & Year(Start_Month), QuarterStart(Start_Month)) as Quarter_IPC

Then Use Sort By Number as ascending

View solution in original post

Highlighted
Not applicable

This also is unfortunately not working !

Highlighted
MVP & Luminary
MVP & Luminary

Hi,

Try like this

Dual('Q' & Ceil(Month(Start_Month)/3) & '-' & Yearname(Start_Month), QuarterSTart(Start_Month)) as Quarter_IPC

Now in Chart Properties -> Sort tab ->  select Numeric Value

Hope this helps you.

Regards,

Jagan.

Highlighted
Not applicable

Thanx Adhimulam!

Marked as right option - Here goes your incentive !

Highlighted
Not applicable

Thanks dude.