Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Custom Sort for Text Variable

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.

9 Replies
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')

Not applicable
Author

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*')

Not applicable
Author

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?

Not applicable
Author

Course Aging# of Total Courses% of Total # Courses
>= 5  Years Old130.60%
First Run27.50%
1-2 Years Old43464.00%
3-4 Years Old23214.80%
marcioarruda
Creator III
Creator III

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

Not applicable
Author

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