Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

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
Author

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

thannk you for your help!

whiteline
Master II
Master II

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