Discussion Board for collaboration on QlikView Layout & Visualizations.
Does anyone know if i can sort fiscal periods in assending order?
Here is what my list box looks like
You can always use dual() function to create values that has both numeric and text representation (in script).
In this case you'll see text representation and use numbers as a sorting order.
Or you can just load your Period field in a proper order with Order By statement (in script) and then use 'load sorting' order.
Hi - i am fairly new to QV. Where and how should i write 'order by statement'?
thannk you for your help!
In the load script, when you load your periods (look at help for syntax).