topic Re: Sorting problem in QlikView

Sorting problem

israrkhan — Mon, 08 Jul 2013 09:36:11 GMT

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

luciancotea — Mon, 08 Jul 2013 09:41:04 GMT

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

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

Gysbert_Wassenaar — Mon, 08 Jul 2013 09:42:04 GMT

Mon, 08 Jul 2013 09:43:22 GMT

see attachement

israrkhan — Mon, 08 Jul 2013 09:50:04 GMT

no attachment is there....

jagan — Mon, 08 Jul 2013 09:57:29 GMT

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 — Mon, 08 Jul 2013 10:11:47 GMT

Thanks to all you guys....