Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Conditional formating on fiscal periods

Hi -

Does anyone know if i can sort fiscal periods in assending order?

Here is what my list box looks like

Period.png

Thank you!

3 Replies
whiteline
Honored Contributor II

Re: Conditional formating on fiscal periods

Hi.

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.

Not applicable

Re: Conditional formating on fiscal periods

Hi  - i am fairly new to QV. Where and how should i write 'order by statement'?

thannk you for your help!

whiteline
Honored Contributor II

Re: Conditional formating on fiscal periods

In the load script, when you load your periods (look at help for syntax).

Community Browser