Forcing a Specific Row to be Listed Last even when Interactive Sorting on Columns

trazerr — Wed, 30 Mar 2022 18:14:38 GMT

Hello,

I am trying to force a specific row of data in a straight table to no matter what always be listed last. Even if the other 7-8 columns of data are interactively sorted this one row always stays listed last.

I am trying to do this by locking the Standard Company Name that I want to stay listed at the bottom of the table.

if([Standard Company Name] = 'Company ABC', dual('Company ABC', 1), [Standard Company Name])

The above works until you interactively sort by any other of the columns such as Revenue Amt, Forecasted Revenue Amt, etc.

Is there a way to call out this one specific Standard Company Name to be listed last even when you sort on other columns? I want it to be part of the table, but to be left out when the sorting changes.

Thanks!

topic Forcing a Specific Row to be Listed Last even when Interactive Sorting on Columns in QlikView

Forcing a Specific Row to be Listed Last even when Interactive Sorting on Columns