Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kshitijas
New Contributor III

Fiscal year

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

year.png

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: Fiscal year

PFA.

I hope it is what you are looking for.

16 Replies
shraddha_g
Honored Contributor III

Re: Fiscal year

Use Expression by Sort :

Add MonthStart Field in Expression editor.

And then Sort Ascending.

I hope It is helpful.

sushil353
Honored Contributor II

Re: Fiscal year

Hi,

See if this can help you Sorting in qlikview

HTH

Sushil

deepaktibhe
Valued Contributor

Re: Fiscal year

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
Contributor II

Re: Fiscal year

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')

kshitijas
New Contributor III

Re: Fiscal year

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
Honored Contributor III

Re: Fiscal year

In that case MonthStart should work in Sorting Expression

kshitijas
New Contributor III

Re: Fiscal year

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
Honored Contributor III

Re: Fiscal year

Try:

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

kshitijas
New Contributor III

Re: Fiscal year

It Starts from Jan

year1.png

Community Browser