QlikView sorting of numeric values problem

[#1]

Hi,

I have created a pivot table with Y and X fields respectively with both showing partial sums labeled as Grand Total, created a Total expression [count(Y)], problem is when do this, chart properties -> sort -> click on Frequency = descending, the figures in Y Grand Total is not being sorted in a descending order which is the result that I wanted. Can anybody please help me?

Thanks in advance

[jagan]

Hi,

Try selecting SubTotals on Top option in

Chart Properties -> Presentation-> SubTotals section.

Regards,

Jagan.

[#3]

Hi Jagan,

Thanks for the reply, although I prefer that the subtotals be on the bottom (SubTotals on Bottom), at the end of X and Y fields assorted in descending order

[jagan]

Hi,

Can you attach sample file and your expected output.

Regards,

Jagan.

[#5]

data looks like this. . .

Status                       ProductType

                                 1way                         2way                 3way              GrandTotal

Accepted                   100                           35                     5                     140                  

Cancelled                   51                             15                    2                      67

Retained                    50                              16                    2                     68

GrandTotal               201                             66                     9                    275

[jagan]

Hi,

Can you attach the sample file?

Regards,

Jagan.

[tresesco]

Sort by expression: Aggr(Sum(Amount), Status)

[#8]

where would I put in this? in Status or ProductType dimension?

[tresesco]

Sort tab->Select Status->Sort by expression..

[#10]

I'm still getting the same result as Sort tab -> Select Status -> Frequency / Numeric Value -> Descending