topic Re: Sorting in QlikView

Sorting

SahrierParvez — Sun, 06 Oct 2019 06:10:32 GMT

Hi,

This is my Dimenssion
I want to sort my data with this dimenssion

=if(Aggr(sum(Gross_Sales),Year,Customer)<0,'Negative Sale',
if(Aggr(sum(Gross_Sales),Year,Customer)=0,'0 Sale',
if((Aggr(sum(Gross_Sales),Year,Customer)>0 and Aggr(sum(Gross_Sales),Year,Customer)<=500),'1-500',
if((Aggr(sum(Gross_Sales),Year,Customer)>500 and Aggr(sum(Gross_Sales),Year,Customer)<=1000),'501-1000',
if((Aggr(sum(Gross_Sales),Year,Customer)>1000 and Aggr(sum(Gross_Sales),Year,Customer)<=3000),'1001-3000',
if((Aggr(sum(Gross_Sales),Year,Customer)>3000 and Aggr(sum(Gross_Sales),Year,Customer)<=5000),'3001-5000',
if((Aggr(sum(Gross_Sales),Year,Customer)>5000 and Aggr(sum(Gross_Sales),Year,Customer)<=10000),'5001-10000',
if((Aggr(sum(Gross_Sales),Year,Customer)>10000 and Aggr(sum(Gross_Sales),Year,Customer)<=30000),'10001-30000',
if((Aggr(sum(Gross_Sales),Year,Customer)>30000 and Aggr(sum(Gross_Sales),Year,Customer)<=50000),'30001-50000',
if((Aggr(sum(Gross_Sales),Year,Customer)>50000 and Aggr(sum(Gross_Sales),Year,Customer)<=100000),'50001-100000',
if((Aggr(sum(Gross_Sales),Year,Customer)>100000 and Aggr(sum(Gross_Sales),Year,Customer)<=500000),'100001-500000',
if(Aggr(sum(Gross_Sales),Year,Customer)>500000,'500000+'

))))))))))))

Re: Sorting

ecolomer — Sun, 06 Oct 2019 07:08:48 GMT

Select option "Load Order"

Re: Sorting

SahrierParvez — Sun, 06 Oct 2019 07:23:34 GMT

Thanks but where is that option load order

please can you give me that screen shot

Re: Sorting

SahrierParvez — Sun, 06 Oct 2019 07:24:57 GMT

I found Load Order but for my window it is disable for me

what can i do

Re: Sorting

ecolomer — Sun, 06 Oct 2019 07:27:23 GMT

Re: Sorting

ecolomer — Sun, 06 Oct 2019 07:30:03 GMT

Do you have any option selected? If yes you can deselected and try

Re: Sorting

ecolomer — Sun, 06 Oct 2019 07:34:56 GMT

What kind of graph or table do you have selected?

Re: Sorting

SahrierParvez — Sun, 06 Oct 2019 08:20:12 GMT

I attached the image

Please Check the file

Re: Sorting

ecolomer — Sun, 06 Oct 2019 08:22:48 GMT

Send me a picture of the sort tab

Re: Sorting

SahrierParvez — Sun, 06 Oct 2019 08:31:19 GMT

Here is the attached file of sort Tab

Re: Sorting

ecolomer — Sun, 06 Oct 2019 08:40:21 GMT

Unselected actual chech and select Load Order

Re: Sorting

ecolomer — Sun, 06 Oct 2019 08:45:18 GMT

Re: Sorting

ecolomer — Sun, 06 Oct 2019 08:46:23 GMT

currently, as it stands, it is ordering you alphabetically by the result of the dimension

Re: Sorting

SahrierParvez — Sun, 06 Oct 2019 08:47:25 GMT

Still it is not working.It is disable still

Re: Sorting

SahrierParvez — Sun, 06 Oct 2019 08:52:42 GMT

So what can i do for sorting

Re: Sorting

ecolomer — Sun, 06 Oct 2019 08:52:45 GMT

you can write in Expression:

=ValueList('Negative Sale', '0 Sale', '1-500', ....)

Re: Sorting

SahrierParvez — Sun, 06 Oct 2019 08:57:32 GMT

=ValueList('Negative Sale', '0 Sale', '1-500','501-1000','1001-3000','3001-5000')

it also not working.

not even changing anything

Re: Sorting

ecolomer — Sun, 06 Oct 2019 09:08:54 GMT

you can write the expression of the dimension but with a number in front.
1. Negative Sale
2. 0 Sale
3. 1-500
...

in order to sort by alfatec text

Re: Sorting

SahrierParvez — Sun, 06 Oct 2019 10:46:18 GMT

Thanks its working but it will be great if you share with me how can i remove the 1. 2. 3. in my front view

Re: Sorting

Brett_Bleess — Mon, 14 Oct 2019 13:28:12 GMT

Review the following Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/The-sortable-Aggr-function-is-finally-here/ba-p/1470262

Regards,
Brett