topic Re: How to have a fixed sort order in straight table based on dimension values in QlikView

How to have a fixed sort order in straight table based on dimension values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a straight table with 1 Dimension and 6 Expressions.

Soring has to be done on the dimension, the order has to be fixed on any selection.

can some please suggest me how to do this asap.

Thanks!

Marcio_Campestrini — Tue, 21 Jun 2016 17:33:36 GMT

Hi Chinnukool

Try to define your sort order and then disable the "Allow interactive sort' option.

Frank_Hartmann — Tue, 21 Jun 2016 18:24:59 GMT

please share a sample! (if u cannot share make samplefile with modification of your dataset)

without knowing your datamodel its gonna be difficult to give advice!

Marcio_Campestrini — Wed, 22 Jun 2016 17:47:05 GMT

Hi chinnukool

Create an inline table at the beginning of the script with the below structure:

OrderTitle:

Load * Inline [

Title

Partner

Of Counsel

Associate

Paralegal ];

And at the end of the script drop this table.

In the chart properties, at sort tab, unmark all options but 'Load Order', and choose 'Original'.

Wed, 22 Jun 2016 17:57:18 GMT

Hi Chinnukool,

You have to just create an inline table with 2 columns.

OrderTitle:

Load * Inline [

Title, SortOrder

Partner,1

Of Counsel,2

Associate,3

Paralegal ,4];

Now sort it on the SortOrder column.

Anonymous — Wed, 22 Jun 2016 17:58:22 GMT

That worked! thanks much for your help!