topic Qlikview Stacked sort not working. in QlikView

Qlikview Stacked sort not working.

Anonymous — Wed, 19 Aug 2015 07:45:02 GMT

I am working on a stacked chart with only 2 expressions resulting in a total volume based on a certain business type.

when i try sorting from highest to lowest in the stacked chart using Y value, it takes one of the business type and not the other

When i use the sort by expression , where i am summing up both the business types and i still get certain values not showing up correctly.

Can any one explain a proper way to do the sorting ?

i am attaching the 2 pictures

in the sort by expression , this is my expression

sum({$<v_Volume_in_Litres,Month=,MonthYear={'$(v_MaxMonthYear_1)'},Year=,[Account Business Cust Type]={'CPT'}>}[PYTHON Value]) + sum({$<v_Volume_in_Litres,Month=,MonthYear={'$(v_MaxMonthYear_1)'},Year=,[Account Business Cust Type]={'FLAT'},[Transaction Product Group]={'Fuel'}>}[PYTHON Value])

Re: Qlikview Stacked sort not working.

Wed, 19 Aug 2015 15:51:33 GMT

Krishna, Please post sample qvw.

Re: Qlikview Stacked sort not working.

Anonymous — Wed, 19 Aug 2015 17:08:20 GMT

If you're using the same expression in expression and sort tab (identical set analysis), that's the right way to do the sorting by expression.

If that's not the problem, please post a sample.

Re: Qlikview Stacked sort not working.

Anonymous — Wed, 19 Aug 2015 21:25:33 GMT

Fernando ,

Yes i am using the same expression in both places , just that in sort expression , i sum both the expressions (FLAT, CPT) and try sorting as total

for a change , i tried with rangesum , aggr but all of them give the same result with minor variation as highlighted in yellow in the picture.