Discussion board where members can get started with Qlik Sense.
Want to show my dimension year and month in fiscal year n month ie. April 2015-March 2016.
I have also used WildMatch in sorting still it doesnt work. Thanks in advance
Go to Solution.
I hope it is what you are looking for.
Use Expression by Sort :
Add MonthStart Field in Expression editor.
And then Sort Ascending.
I hope It is helpful.
See if this can help you Sorting in qlikview
Try this: Use date function Date(MonthStart([Treatment Start Date]), 'MMM') and go to sorting and use this on top, your chart will get filtered on month field.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
try below match function
I have data from year from 2014-2016 and want to display from financial year ie.
In that case MonthStart should work in Sorting Expression
I have used the following expression in sort by expression:
Can you tell me what changes to make in this?
MonthStart(FromDate) in Sort by Expression instead of wildmatch.
It Starts from Jan