Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlikview sort by expression

Hello guys am back again with a sort by expression issue

In continuation to the question i asked earlier in the link below

https://community.qlik.com/thread/177092

i have the expression below but my sort using the 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])

is always taking the largest of first expression and adding to the second expression and total is sorted based on the final total. 

to illustrate further i have the example dataset attached.

i have the table with dimension limits set to top 20 and top 30 in 2 different screens. some of them marked in yellow are in 30 but not when i set to top 20. This is happening due to the value of CPT being lower but the overall total along with FLAT is higher.

Capture.PNG

can any one explain why this is happening ?

0 Replies