topic Re: sort the dimension in QlikView

sort the dimension

Thu, 29 Nov 2012 09:23:38 GMT

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

Thu, 29 Nov 2012 09:40:30 GMT

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

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

jagan — Thu, 29 Nov 2012 09:45:26 GMT

Hi,

Hope attached file helps you.

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

Regards,

Jagan.

Thu, 29 Nov 2012 09:47:59 GMT

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

3~19

20+

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

jagan — Thu, 29 Nov 2012 09:52:26 GMT

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.

Thu, 29 Nov 2012 09:55:36 GMT

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

Thu, 29 Nov 2012 10:10:23 GMT

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!