Need help in dual function

[vikasshana]

Hi,

I've a pivot table like below in my Qlikview app.

Test	Server	sum(sales1)	Sum(Sales)
A	1		50
	2		90
	3		100
B	23	60
	34	48
	54	56

I would like to sort the sum(sales) based on server dimension and I'm using below expression in the sort tab of the pivot table.

dual(Test='A',sum(sales))

And I'm getting the output as below.

Test	Server	sum(sales1)	Sum(Sales)
A	3		100
	2		90
	1		50
B	23	60
	34	48
	54	56

Now my requirement is I would like to sort both the 'Tests(A and B)' and I'm trying the below expression and is giving me the error message saying it is not possible.

dual(Test='A',sum(sales),

dual(Test='B',sum(sales1))

I would like to see output as below,

Test	Server	sum(sales1)	Sum(Sales)
A	3		100
	2		90
	1		50
B	23	60
	54	56
	34	48

Regards,

Vikas

[Anil_Babu_Samineni]

May be

dual(Test='A' or Test='B',sum(sales))

[vikasshana]

Sorry Anil, I just edited my question

[Anil_Babu_Samineni]

Why 34 and 54 interchange?

[vikasshana]

I want that sorted based on the highest value, so that's why they got interchanged.

[sunny_talwar]

I see you have changed your requirement a little bit, so you don't want this any more?

Dimension

Test

=Aggr(Dual(Server, Sum(Sales)), Test, Server)

Expression

=If(Test = 'B', Sum(Sales))

=If(Test = 'A', Sum(Sales))

Sort tab

Make sure to sort numerically the second dimension by descending order

[vikasshana]

No sunny, I'm using different expression sum(sales) and sum(sales1).

[sunny_talwar]

How does it matter....Changed the data to this

LOAD * INLINE [

    Test, Server, Sales, Sales1

    A, 1, 50

    A, 2, 90

    A, 3, 100

    B, 23, , 60

    B, 34, , 48

    B, 54, , 56

];

and use this

Dimension

Test

=Aggr(Dual(Server, Sum(Sales)+Sum(Sales1)), Test, Server)

Expression

=If(Test = 'B', Sum(Sales1))

=If(Test = 'A', Sum(Sales))