topic Re: Sort Data in QlikView

Sort Data

Anonymous — Wed, 13 Jan 2016 02:55:23 GMT

Hi, i Have a question about sorting data shown in pivot table.

I have data like this:

Color No.

Red 1

Blue 2

Green 3

The data sorted by Color name (alphabet) by default, now i want to sort the data by "No." field.

Do you have any idea ?

Thanks in advance.

Re: Sort Data

tamilarasu — Wed, 13 Jan 2016 03:10:14 GMT

A pivot table is always sorted first after the first dimension, then the second dimension, like wise.

Promote your Number dimension above the color dimension.

Re: Sort Data

jagan — Wed, 13 Jan 2016 03:11:30 GMT

Hi,

Try like this

LOAD

Dual(ColorName, Match(ColorName, 'Red', 'Blue', 'Green')) AS ColorName,

FROM DataSource;

Now in Sort tab select Numeric Value

Hope this helps you.

Regards,

jagan.

Re: Sort Data

Wed, 13 Jan 2016 04:17:29 GMT

go to the sort tab promote the number dimension or demote the color dimension.then select Number dimesion and in right panel select the checkbox numeric asscending

Re: Sort Data

HirisH_V7 — Wed, 13 Jan 2016 04:36:34 GMT

Hi ,

If you want the Same sort as you loaded means you can go with Load Order in Pivot Table Sort for each dimension.

Else ,

You can write like this in your sort expression for Color,

=IF(PIck(Match(No,'1','2','3'),'1','2','3'),No)

Hope this Helps,

Hirish

Re: Sort Data

saniyask — Wed, 13 Jan 2016 05:45:00 GMT

Hi,

As per your question u want the data to be sorted according to the 'No.' field..

you can simply go to chart properties ->Sort->in the dimension column just removing all sort of sorting that is pre applied and click on No. field and sort it the way u want it i.e ascending or descending..

Hope that will help you !!

Thanks & Regards,

Saniya

Re: Sort Data

Wed, 13 Jan 2016 05:50:52 GMT

No. field should be the first field in the Pivot table.

Re: Sort Data

engishfaque — Wed, 13 Jan 2016 07:36:33 GMT

Dear Lejours88,

Kindly find attached App, I hope you are looking for that one.

Kind regards,

Ishfaque Ahmed

Re: Sort Data

Wed, 13 Jan 2016 08:00:14 GMT

HI Lejours,

Please find the attachment . I think it will help to proceed further .