topic Re: Sorting Issue in QlikView

Sorting Issue

nihhalmca — Fri, 19 Dec 2014 08:12:02 GMT

Hi All,

I have filed Month has Jan, Feb, Mar.....Dec

Suppose if i select FEB selected value should be appeared last in filed(if gives sort order is Ascending) else first in field (if gives sort order is Descending).

My requirement is not change the place of value in filed. ex: if i select FEB it should appear 2nd place in field.

I hope you people understand my requirement.

Thanks you,

Regards,

Nihhal.

Re: Sorting Issue

preminqlik — Fri, 19 Dec 2014 08:18:07 GMT

go to list box properties >> sort tab>>

sort by expression >>=only(num(Month(Date#(Monthfieldname,'MMM'))))

Re: Sorting Issue

nihhalmca — Fri, 19 Dec 2014 08:29:36 GMT

Hi Prem Kumar,

Not working. it gives the same result.

Re: Sorting Issue

Anonymous — Fri, 19 Dec 2014 08:38:09 GMT

hi follow this,

In the properties > Sort tab > Select Dimension >Please check on the right side expression and enter like

= u r monthfiled

hope it will helps..

Re: Sorting Issue

nihhalmca — Fri, 19 Dec 2014 08:43:19 GMT

Hi Sreekanth,

Not working.

Re: Sorting Issue

Anonymous — Fri, 19 Dec 2014 08:52:52 GMT

Hi Use the following expression in

sort tab select dimension and select the expression in that expression write the code like this

=If(Monthname='Jan',1,If(Monthname='FEB',2,If(Monthname='MAR',3,If(Monthname='APR',4,If(Monthname='MAY',5,If(Monthname='JUN',6,If(Monthname='JUL',7,If(Monthname='AUG',8,If(Monthname='SEP',9,If(Monthname='OCT',10,If(Monthname='NOV',11,If(Monthname='DEC',12)))))))))))))))))

Re: Sorting Issue

alkesh_sharma — Fri, 19 Dec 2014 08:56:41 GMT

Use dual while creating the months, the best way to overcome sorting issues. or sort-> state-> auto ac ascending might work.

Re: Sorting Issue

jagan — Fri, 19 Dec 2014 09:00:57 GMT

Hi,

Properties -> Sort -> Select Field -> Uncheck State option.

Regards,

Jagan.

Re: Sorting Issue

nihhalmca — Fri, 19 Dec 2014 09:11:33 GMT

Hi jagan, thanks for your response.

Not working. anyways i got solution by sreekanth.

Regards,

Nihhal.

Re: Sorting Issue

isorinrusu — Fri, 19 Dec 2014 09:15:54 GMT

Nihhal, although that solution works, it's not the best by far. You'd better look for a more performant solution.

For example, try to associate a number to each month. Then sort it as you would normally do.

Re: Sorting Issue

nihhalmca — Fri, 19 Dec 2014 09:17:45 GMT

Hi Sorin,

You are talking about ApplyMap().

Re: Sorting Issue

alkesh_sharma — Fri, 19 Dec 2014 09:19:17 GMT

I agree, Best way is to use DUAL function at script level and give each month a number and than sort through number

Re: Sorting Issue

isorinrusu — Fri, 19 Dec 2014 09:38:44 GMT

No, not exactly.

You will find a QVW file attached.

The first table has month and month #. The second one only month. If you delete all sorting options in the selector that has the month value associated, the months will be automatically sorted according to the month number that you gave to each month.

The month selector withouth the number associated will not be ordered automatically.

Regards,

Sorin.

Re: Sorting Issue

jagan — Fri, 19 Dec 2014 10:04:15 GMT

Hi Nihhal,

I think instead of using 12 Ifs use Match()

Match(Monthname, 'Jan', 'Feb', 'Mar', 'Apr', 'May'..........)

Regards,

Jagan.

Re: Sorting Issue

nihhalmca — Fri, 19 Dec 2014 10:28:48 GMT

Hi Jagan,

If i use match() in this case, sorting issue will be occurred. (please see at my posted question).

Regards,

Nihhal.

Re: Sorting Issue

Fri, 19 Dec 2014 10:35:48 GMT

Use the following expression in

sort tab select dimension and select the expression in that expression write the code like this

=Wildmatch(Monthname,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')