Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
how to sort , so Region must be at first..
Many Thanks in advance....
Go to Solution.
In the "Sort" tab, use "Sort by expression" and add
=if( MyDimension = 'Region', 1, 2)
See this blog post: Establishing a Sort Order
no attachment is there....
In the script itself use dual function to specify the sort order
If(Dimension= 'Region', Dual(Dimension, 1), Dual(Dimension, 2) AS Dimension
Now in sort tab specify Numeric as sort type.
Hope this helps you.
Thanks to all you guys....