topic Re: Custom Sort for Text Variable in QlikView

Custom Sort for Text Variable

Fri, 10 Mar 2017 17:50:27 GMT

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.

Re: Custom Sort for Text Variable

sunny_talwar — Fri, 10 Mar 2017 17:54:29 GMT

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

Re: Custom Sort for Text Variable

Fri, 10 Mar 2017 17:57:19 GMT

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

Also, the Values have quotes in them.

Re: Custom Sort for Text Variable

sunny_talwar — Fri, 10 Mar 2017 17:59:50 GMT

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

Re: Custom Sort for Text Variable

Fri, 10 Mar 2017 18:04:00 GMT

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

Re: Custom Sort for Text Variable

sunny_talwar — Fri, 10 Mar 2017 18:07:26 GMT

Would you be able to share a sample or screenshots?

Re: Custom Sort for Text Variable

Fri, 10 Mar 2017 18:12:36 GMT

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%

Re: Custom Sort for Text Variable

Anonymous — Fri, 10 Mar 2017 18:16:43 GMT

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

Re: Custom Sort for Text Variable

Fri, 10 Mar 2017 18:19:14 GMT

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

Re: Custom Sort for Text Variable

sunny_talwar — Fri, 10 Mar 2017 18:20:16 GMT

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