topic Re: Sorting issue in QlikView

Sorting issue

Anonymous — Thu, 02 Jul 2015 09:05:53 GMT

Hi Everybody,

I am facing one sorting issue in month names.

i want it in calendar wise sorting ie: jan feb march april etc.

Attached is the screen shot for the same.

Please assist.

Re: Sorting issue

alexandros17 — Thu, 02 Jul 2015 09:08:33 GMT

Use DUAL function to sort ...

Re: Sorting issue

giakoum — Thu, 02 Jul 2015 09:09:16 GMT

dual or make sure the load order is the one required

Re: Sorting issue

Gysbert_Wassenaar — Thu, 02 Jul 2015 09:10:00 GMT

I expect that your Month field contains only text values and not numeric values. Perhaps you can create that field so it contains dual values that have both a numeric value and a textual display format. Or you can try sorting by an expression like match({1} Month, 'Januari', 'Februari', ...etc.., 'December')

Re: Sorting issue

avinashelite — Thu, 02 Jul 2015 09:12:02 GMT

Hi Gaurav,

while creating the month , have both the format created i.e. text and number ....

then use dual function with that , this will solve the issue.

EG:

Load dual(month_name,month_number) as month_name

;

Re: Sorting issue

hic — Thu, 02 Jul 2015 09:14:42 GMT

Then you should define your month using the Month() function. If you have the month names in a field, you can do this by defining your field by

Month(Date#(MonthName,'MMMM')) as Month

HIC

Re: Sorting issue

Anonymous — Thu, 02 Jul 2015 09:18:57 GMT

Hi Avinash,

cloud't get you.

Please provide some examples.

Re: Sorting issue

Anonymous — Thu, 02 Jul 2015 09:36:06 GMT

Thanks Henric,

Now i got it

Cheers !!