Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

sort the dimension

I want to sort  the dimension in ascending order.

The values of dimension are  (varchar type) : 0,1,2,3~19,20+

I've try to write expression to sort these values.But it didn't work.

Anyone can help?

Thank you

1 Solution

Accepted Solutions
MVP
MVP

Re: sort the dimension

HI,

Do the following

Select Chart Properties -> Sort -> Select Sort by -> Expression

=Match(DimensionName, '0', '1', '2', '3~19', '20+')

Hope this helps you.

Regards,

jagan.

6 Replies
Not applicable

Re: sort the dimension

IF(yourfield < 3, yourfield, IF(yourfield = '3~19', 3, 4))

Put the calculation in sort by Expression under the Sort-tab

MVP
MVP

Re: sort the dimension

Hi,

Hope attached file helps you.

Select Chart Properties -> Sort -> Select Sort by -> Text and uncheck others.

Regards,

Jagan.

Not applicable

Re: sort the dimension

The 3~19 ia an interval, so the result shoud be:

0

1

2

3~19

20+

Numerical sorting doesn't work here, need to be an expression.

MVP
MVP

Re: sort the dimension

HI,

Do the following

Select Chart Properties -> Sort -> Select Sort by -> Expression

=Match(DimensionName, '0', '1', '2', '3~19', '20+')

Hope this helps you.

Regards,

jagan.

Not applicable

Re: sort the dimension

Or just do as i wrote in the first response: IF(yourfield < 3, yourfield, IF(yourfield = ',3~19', 3, 4))

Not applicable

Re: sort the dimension

no it's not working.

The result is  0 ,20+, 1 ,2, 3~19

An match methos is ok.

And Inspired by you ,my solution is if(Logins = '20+',4,if(Logins = '3~19',3,Logins))

Thank you all!

Community Browser