topic Re: How do I create a Financial Year dimension from date? in QlikView

How do I create a Financial Year dimension from date?

Thu, 29 Nov 2012 11:32:21 GMT

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

Re: How do I create a Financial Year dimension from date?

Gysbert_Wassenaar — Thu, 29 Nov 2012 12:37:12 GMT

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;

Re: How do I create a Financial Year dimension from date?

Thu, 29 Nov 2012 13:25:09 GMT

Thankyou