In Above(), Sort is not working as desired

[#1]

Please find the attached app.

I am using a straight table with 3 dimensions and 2 expressions. One of my dimensions [Party Name] is a calculated dimension.

From Help files of QlikView, I understood that Above() function work by the sort order in 'Sort' tab.

My desired sort order is: Name of the state -> Parliamentary Constituency -> Total Votes Polled -> Party Name -> Incremental.

'Incremental' is the column where I am using above() function. But this is not following the sort order I mentioned above.

[vicky_qv]

If the table is having multiple dimensions, the current column segment will only include rows with the same values as current row in all dimension columns except for the column showing the last dimension in the inter field sort order.

Here current column segments will be created for Name of State & Parliamentary Constituencies

Last dimension (inter filed) : Party Name

Based on this , the above() is calculated on the Total votes polled.

[#3]

Can someone please help?

[PradeepReddy]

are you looking something like this...

[avinashelite]

could you please share the expression which is causing the problem ?(I don't have the QV licence)

I think you are facing the problem with the segmentation above function work on the segment , which might cause the issue some time ...try to add the TOTAL qualifier this will help you to over come the segmentation problem   

[#6]

But then it is written in help file as : "If the table or table equivalent has multiple vertical dimensions, the current column segment will include only rows with the same values as the current row in all dimension columns except for the column showing the last dimension in the inter field sort order. The inter field sort order for pivot tables is defined simply by the order of the dimensions from left to right. For other chart types this can be manipulated in the Chart Properties: Sort dialog."

So I am assuming that even the last dimension's order can be manipulated in Sort tab. Is my assumption wrong?

[Gysbert_Wassenaar]

I don't think you can be helped. As far as I know the above() function doesn't honor expressions in the sort list. As soon as you add an expression with an above() in it you lose the sorting by the expressions in the sort list.

[#8]

I am sorry but this is not what I am looking for. First in your app I saw the third dimension is not calculated one and I also find that in your app, Sort order on first expression [Total Votes Polled] is not working.

[#9]

Thanks Gysbert. I was under the impression that it could be manipulated as I read from help file: "For other chart types this can be manipulated in the Chart Properties: Sort dialog."

So does that mean Above() function always follow the last dimension's order in a segment irrespective of whatever is in "Sort" tab?

[#10]

Hi Avinash...I am using two expressions:

1st expression: sum([Total Votes Polled])

2nd expression: sum([Total Votes Polled])-above(total sum([Total Votes Polled]))

Dimensions are Name of the state, Parliamentary Constituency, Party Name

Sort order : Name of the state -> Parliamentary Constituency -> 1st expression -> Party Name -> 2nd expression.