topic Re: QlikView sorting of numeric values problem in QlikView

QlikView sorting of numeric values problem

Wed, 28 Jan 2015 01:30:06 GMT

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

Re: QlikView sorting of numeric values problem

jagan — Wed, 28 Jan 2015 02:04:56 GMT

Hi,

Try selecting SubTotals on Top option in

Chart Properties -> Presentation-> SubTotals section.

Regards,

Jagan.

Re: QlikView sorting of numeric values problem

Wed, 28 Jan 2015 02:18:07 GMT

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

Re: QlikView sorting of numeric values problem

jagan — Wed, 28 Jan 2015 03:29:24 GMT

Hi,

Can you attach sample file and your expected output.

Regards,

Jagan.

Re: QlikView sorting of numeric values problem

Wed, 28 Jan 2015 03:35:11 GMT

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

Re: QlikView sorting of numeric values problem

jagan — Wed, 28 Jan 2015 03:53:52 GMT

Hi,

Can you attach the sample file?

Regards,

Jagan.

Re: QlikView sorting of numeric values problem

tresB — Wed, 28 Jan 2015 05:07:32 GMT

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

Re: QlikView sorting of numeric values problem

Wed, 28 Jan 2015 06:06:49 GMT

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

Re: QlikView sorting of numeric values problem

tresB — Wed, 28 Jan 2015 06:26:14 GMT

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

Re: QlikView sorting of numeric values problem

Wed, 28 Jan 2015 06:57:33 GMT

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

Re: QlikView sorting of numeric values problem

tresB — Wed, 28 Jan 2015 07:12:07 GMT

Check attached qvw, if that is how you want.

Re: QlikView sorting of numeric values problem

Wed, 28 Jan 2015 08:02:57 GMT

this one is missing the subtotal at the bottom, if you would look at my example above, the GrandTotal on the bottom is following the descending format but the GrandTotal on the right isn't because the Retained Status for the 2 way ProductType is bigger than the Cancelled Status of the 2 way ProductType and I think that is the source of my problem

Re: QlikView sorting of numeric values problem

tresB — Wed, 28 Jan 2015 08:19:37 GMT

Well, I guess it's clear now. Then, you would need two sort expressions for two dimensions. Check attached.

Re: QlikView sorting of numeric values problem

Wed, 28 Jan 2015 08:27:39 GMT

I have tried that as well but the sample data that you indicated doesn't have the problem with data that I indicated above that is showing in the sample graph that I also posted. . . "because the Retained Status for the 2 way ProductType is bigger than the Cancelled Status of the 2 way ProductType and I think that is the source of my problem"