Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Specifying a specific ordering of values in table

Hi all,

I have a column (e.g. field_A), which has 4 unique values.

Field_A                        freq

-----------                        -----

Value_s                        4

Value_x                        3

Value_y                        7

Value_r                        2

I want to display this field in a straight table with a freq (which I can do) but I want to order field_A values in a specific order (not in ascending or descending) that I would like to define manually.

Any ideas?

Regards

Revlin

1 Solution

Accepted Solutions
MVP
MVP

Re: Specifying a specific ordering of values in table

You should be able to use an expression to return your sort order (i.e. a numerical) in sort tab of the straight table, maybe something like

=match(Field_A, 'Value_s','Value_x','Value_y','Value_r')

5 Replies
Not applicable

Re: Specifying a specific ordering of values in table

specify the load order for fieldA using a inline load. In the sort order use expression and specify the new field.

Like:

Load * Inline[

Field_A,SortOrder

Value_s,2

Value_x,3

Value_y,1

Value_r,4

];

Kiran Rokkam.

MVP
MVP

Re: Specifying a specific ordering of values in table

You should be able to use an expression to return your sort order (i.e. a numerical) in sort tab of the straight table, maybe something like

=match(Field_A, 'Value_s','Value_x','Value_y','Value_r')

Not applicable

Re: Specifying a specific ordering of values in table

Hi

I think

=match(Field_A, 'Value_s','Value_x','Value_y','Value_r')

is the way to go but it doesn't seem to work.

MVP
MVP

Re: Specifying a specific ordering of values in table

This should work, please check attached sample.

Field_A has to be your field name you want to sort, with the values the exact field values (all case sensitive).

Not applicable

Re: Specifying a specific ordering of values in table

Actually it does it work, thank you.

Community Browser