Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Straight Table Sort by Expression

Hi Community!

I have a straight table with some calculated fields and other fields have expressions:

sort_correct.PNG

Columns with expressions:

Column 4: aggr(only({<[CALL SERVICE TYPE]={'EM','PM','IS','ROP'}>} [SERVICE NO.]), [SERVICE NO.])

Column 13: if([CALL SERVICE TYPE]='EM' and [PROBLEM TYPE]='HW' and not([REPAIR CODE]>=40 and [REPAIR CODE]<=43) and (above(total [MIF SERIAL])=[MIF SERIAL] and [SO DATE]-above(total [SO DATE])<=7),1,0)


Now there a catch, Column 3 then Column 4 must be sorted ascending to compute the value for Column 13 and 14 but I want to remove the Column 3 and sort by Column 1 and it is affecting the result by just changing the sort criteria.

sort_wrong.PNG

Again, the goal is to remove the Column 3, but retaining the sort order [via some expressions(?)] to achieve the same result shown in image 1.

Thank you!

0 Replies