# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

## Sorting Problem in Pivot Table ..

Hi Frnz,

I have pivot table. In this, it is showing Top 15 Accounts. I have done pivoting on YEAR.

I need to do sorting by 2015 values ? Is it possible to show Totals in last row by year wise ?

1 Solution

Accepted Solutions
New Contributor II

## Re: Sorting Problem in Pivot Table ..

Hi!
You should use the expression:

sum({<Year={"2015"}>}Sales)

Put it in your sorting tab under AccountName, make sure its descending, and that al other sorting under Year is off.

13 Replies
Not applicable

## Re: Sorting Problem in Pivot Table ..

Hi

I Don't think so row wise sorting in qlikview

Valued Contributor

## Re: Sorting Problem in Pivot Table ..

Hi Tulasi,

Can you please attach sample file.It will be easy to sort out your problem .

Honored Contributor

## Re: Sorting Problem in Pivot Table ..

I am not sure,but give it a try

goto sort tab and select your expression

define: =sum({<YEAR={'2015'}>}Value) descending

Not applicable

## Re: Sorting Problem in Pivot Table ..

Hi,

Please check attached Qvw. I need Sorting in 2015 values. And is it possible to show Totals in Year wise.?

Not applicable

## Re: Sorting Problem in Pivot Table ..

Hi,

I need descending order for 2015 values. Please find the attached QVW.

Honored Contributor III

## Re: Sorting Problem in Pivot Table ..

Doesn't look easy in Pivot table, below is relevant post on this -

Sorting in pivot tables

Valued Contributor

## Re: Sorting Problem in Pivot Table ..

Hi ,

Is this???

New Contributor II

## Re: Sorting Problem in Pivot Table ..

Hi!
You should use the expression:

sum({<Year={"2015"}>}Sales)

Put it in your sorting tab under AccountName, make sure its descending, and that al other sorting under Year is off.

Not applicable

## Re: Sorting Problem in Pivot Table ..

Hi,

Yes exactly i need like this. When I use this expression, I am getting like below image. I need 2015 values in top of the table.