Discussion Board for collaboration related to QlikView App Development.
Basically, I want to fix sequence according to financial months
1. I tried it using wildmatch,match
2.Also, tried with if else condition.
But nothing is working.Please suggest me.
There are various ways you can achieve this:
Put below in sort by expression.
Set the arrangement to Ascending
note: you can also change the sequence of Jan,Feb,Mar,etc by changing the sequence in Match function.
It might be your month name is not matching.
To check that put below expression in list box and see if you get a list of values ranging from 1-12.