Fiscal year

[Karahs]

Hello everyone,

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

[shraddha_g]

Use Expression by Sort :

Add MonthStart Field in Expression editor.

And then Sort Ascending.

I hope It is helpful.

[sushil353]

Hi,

See if this can help you Sorting in qlikview

HTH

Sushil

[deepakqlikview_123]

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.

[stephenedberkg]

hi ,

Properties->sort->Expression

try below match function

Match(Datefield,'Apr-15','May-15',Jun-15,'Jul-15','Aug-15', 'Sep-15','Oct-15','Nov-15','Dec-15','Jan-16','Feb-16','Mar-16')

[Karahs]

I have data from year from 2014-2016 and want to display from financial year ie.

Apri-2014-Mar-2015

Apr-2015-Mar-2016......so on..

[shraddha_g]

In that case MonthStart should work in Sorting Expression

[Karahs]

I have used the following expression in sort by expression:

Wildmatch(month(FromDate),'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar')

Can you tell me what changes to make in this?

[shraddha_g]

Try:

MonthStart(FromDate) in Sort by Expression instead of wildmatch.

[Karahs]

It Starts from Jan