topic Re: How to do 2 sort on the same table in QlikView

How to do 2 sort on the same table

Anonymous — Tue, 13 Oct 2015 15:02:50 GMT

Good Afternoon,

I have a problem with two "sort" on the same table.

I have two dimensions Product and Customer and two metrics Value and Price.

The goal was to create a Bottom 3 of Customers by Product, I had to apply a formula so it does not consider the zeros.

But now I want to do two sort on the same table, so I want to do "sort" the Customers by Price (Ascending) and then I still want to do "sort" the Products By Value (Only for Total Product - Descending).

What is happening now is the table does the "sort" for total of all values and not by total of the three values on the table (Partial Total), although show the right totals.

You may confirm the example (.qvw) (In Attachment).

The result I wanted to present is:

Customer	Product	Value	Price
10	D	0	-1
5	D	5	0,5
12	D	4	0,65
Total	Total D	9	0,15
5	B	-1,5	-0,25
17	B	4	2
20	B	4	2
Total	Total B	6,5	3,75
9	A	-3,6	-2,3
8	A	3	1
6	A	5	2,5
Total	Total A	4,4	1,2
2	C	0	-0,3
6	C	1	1,6
9	C	-4,8	2
Total	Total C	-3,8	3,3

I hope someone can help me.

Thanks in advance.

Ana

Re: How to do 2 sort on the same table

Anonymous — Fri, 16 Oct 2015 08:22:23 GMT

Some suggestion, please?

Re: How to do 2 sort on the same table

raajaswin — Fri, 16 Oct 2015 11:20:44 GMT

Hi,

Try by giving sort condtion as expression aggr(sum(),) with ur necesary column

Re: How to do 2 sort on the same table

Anonymous — Fri, 16 Oct 2015 11:45:32 GMT

The table has the same behavior.

I already try many things but the table keeps the "sort" of all values. I need to do the "sort" just to values on the table.

Re: How to do 2 sort on the same table

raajaswin — Fri, 16 Oct 2015 12:14:21 GMT

up to my knowledge,I think the problem is in your expression used. i tried removing the '-' you used in your expression it is working. but the logic becomes wrong now. So try building some other expression. It may work

Re: How to do 2 sort on the same table

raajaswin — Fri, 16 Oct 2015 12:16:07 GMT

Hi,

Re: How to do 2 sort on the same table

avinashelite — Fri, 16 Oct 2015 12:20:14 GMT

You can enable the interactive sort option based on the user needs you can sort the same .

Re: How to do 2 sort on the same table

Anonymous — Fri, 16 Oct 2015 12:26:33 GMT

hi ana,

please have a look at below post if you are looking for sort in Pivot:

Second Dimension Sort w/ Expression

Re: How to do 2 sort on the same table

Anonymous — Fri, 16 Oct 2015 14:54:15 GMT

Hello Everyone

Thanks for your help, but I already solved my problem.

I've attached the example qvw with solution, if someone has interested.

Ana