Custom Sort for Text Variable

[#1]

Hi,

I have a calculated dimension if(Year = 'Current', [Current Course Age], [Previous Course Age] ) and I have labeled it as Course Aging.

The possible values under Current Course Age], [Previous Course Age] are

"First Run"

"1-2 Years Old"

"3-4 Years Old"

">=5 Years Old"

I want to be able to sort the calculated dimension in the order mentioned above.

Thanks!

Edit:Also, the Values have quotes in them.

[sunny_talwar]

May be this:

Match(

If(Year = 'Current', [Current Course Age], [Previous Course Age]),

'First Run'

'1-2 Years Old'

'3-4 Years Old'

'>=5 Years Old')

[#3]

I tried this expression under sort--> Expression. This did not work.

Also, the Values have quotes in them.

[sunny_talwar]

There is quotes... okay, try this may be

WildMatch(

If(Year = 'Current', [Current Course Age], [Previous Course Age]),

'*First *'

'*1-2 Years Old*'

'*3-4 Years Old*'

'*>=5 Years Old*')

[#5]

Still does not work. I am using

=WildMatch(if (Year= 'Current' ,[CurrentCourseAgeDescription],[Previous Course Age Description]),'*First Run*', '*1-2 Years Old*','*3-4 Years Old*', '*>=5 Years Old*')

[sunny_talwar]

Would you be able to share a sample or screenshots?

[#7]

Course Aging	# of Total Courses	% of Total # Courses
>= 5  Years Old	1	30.60%
First Run	2	7.50%
1-2 Years Old	434	64.00%
3-4 Years Old	232	14.80%

[Anonymous]

I think you should use this expression in Sort / Sort by / Expression.

[#9]

I am using the expression in Sort / Sort by / Expression.

[sunny_talwar]

Hahahaha this is not what I asked for.... Would you be able to share a qvw app or may be some raw data?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample