How do I create a Financial Year dimension from date?

[#1]

Hi All,

I'm new to Qlikview & this is my 1st post.

I have a database link set up into my qlikview file, & I want to be able to view the data by Financial Year (Apr-Mar), I can't get any of the previous post replies on similar queries to work on my data.

This is an extract from my script:

I've tried adding both of the following commands into the script seperately, but neither worked:

they bring up an error message saying:

Can anyone suggest what i need to do?

Many Thanks

[Gysbert_Wassenaar · Accepted solution]

Yearname is a Qlikview function, so you can't use it in sql statements. Use a preceding load:

load *, yearname(date,0,4) as Financial Year;

sql select .... etc;

[#3]

Thankyou