List Of Months in current finantial year

[#1]

Hello ,

     how can i get current financial year months like right now finantail year 2014-2015 is going on and current month is june ,i need to create such a field it should store months Apr May June just three if july comes up it should add july to its list... i need help asap,

thank you

[tresesco]

You could try like:

Load

          Month(InQuarter(Today(), YourDateField, 0)) as ThisQuarterMonths

[#3]

hi , this my table structure how can i do in this ,

[#4]

i dont have date field ,what should i use ?

[tresesco]

So you don't have a date field. Well try like:

Load

          Month(InQuarter(Today(), Makedate(1,Month,1), 0)) as ThisQuarterMonths

[#6]

hi,

by using Month(InQuarter(Today(), Makedate(1,Month,1), 0)) as ThisQuarterMonths i am only getting december ,,??
i should get apr may june right?

[tresesco]

Could you post your sample qvw?

[#8]

due to security reasons i cant ,sorry

[tresesco]

You don't have to be. Just need to know: Preparing examples for Upload - Reduction and D... | Qlik Community

[hic]

See http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

HIC