Sorting issue on Expression - Pivot table - grouped based on Dimension

Wed, 16 Sep 2015 10:16:05 GMT

Hi All,

i'm stuck with an issue ,

I need to apply sorting on

Chart --> Pivot table

based on Group Dimension - Ascending Order

Expression 1- Descending Sort - Sum

Expression 2- Descending Sort - %

Scenario1 : when iam selecting a individual LIST of Value(single) in Dimension it works fine , (but we ned to display with all values in the dimesnion)

Scenario2 : when selected with ALL LIST of values(ALL) , the sort order getting changed for expressions

Scenario3: when the pivot table is changed as straight table and the particular dimension removed all the sum (desc), and % (desc), and rank appears correctly

if this works , if possible i need to add Rank in Ascending order (1..N), while expression value is in descending order(sum highest to lowest)

thanks in advance.

it would be helpful , if i get possible workarounds , solutions , in case if someone has faced similar kind

topic Sorting issue on Expression - Pivot table - grouped based on Dimension in QlikView

Sorting issue on Expression - Pivot table - grouped based on Dimension