Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Karahs
Partner - Creator
Partner - Creator

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

16 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Create the Fiscal Month using the script in below link

Fiscal and Standard Calendar generation

Now just select numeric in Sort tab.

Hope this helps you.

Regards,

jagan.

stephenedberkg
Creator III
Creator III

Hi,

my date field also like you

Aug-15,sep-15 so on....just set the numeric values as ascending .refer the below image

sorting.png

!

prabiradhikary
Partner - Contributor III
Partner - Contributor III

Use ORDERBY Date field in datamodel and Properties->sort->Load Order -> Original

shraddha_g
Partner - Master III
Partner - Master III

PFA.

I hope it is what you are looking for.

Karahs
Partner - Creator
Partner - Creator
Author

Awesome,it worked. Appreciate your quick response.

Thankyou

shraddha_g
Partner - Master III
Partner - Master III

Great.

wossenhh
Creator
Creator

Hi Shraddha,

Could you please post in qvw instead of qvf?

Thanks for your help

Wossen