Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

israrkhan
Valued Contributor II

Sorting problem

Hi Guys:

i have one dimension in my straight table and many expressions.

what i want to do, i want to sort my dimension in any way, but want to keep my "Region"  in first row,

for example i have dimension values, as BELOW.

ABD

DEF

Region

RBG

SSS

and so....

how to sort , so Region must be at first..

Many Thanks in advance....

Regards

Khan

1 Solution

Accepted Solutions
Not applicable

Re: Sorting problem

see attachement

6 Replies
luciancotea
Valued Contributor

Re: Sorting problem

In the "Sort" tab, use "Sort by expression" and add

=if( MyDimension = 'Region', 1, 2)

Re: Sorting problem

See this blog post: Establishing a Sort Order


talk is cheap, supply exceeds demand
Not applicable

Re: Sorting problem

see attachement

israrkhan
Valued Contributor II

Re: Sorting problem

no attachment is there....

MVP
MVP

Re: Sorting problem

Hi Usman,

In the script itself use dual function to specify the sort order

LOAD
     *,

     If(Dimension= 'Region', Dual(Dimension, 1), Dual(Dimension, 2) AS Dimension

FROM DataSource;

Now in sort tab specify Numeric as sort type.

Hope this helps you.

Regards,

Jagan.

israrkhan
Valued Contributor II

Re: Sorting problem

Thanks to all you guys....

Community Browser