topic Re: Wrong Financial Year in QlikView

Wrong Financial Year

nikhilgarg — Mon, 16 Mar 2015 11:52:41 GMT

Hey,

I tried calculating the Quarter value but it doesnot give me correct quarter value.

I am using following as expression:

'Q'& Ceil(if(Month(CreateDate) > 10 , Month(CreateDate) - 10 , Month(CreateDate)+2)/3.0)

And Create Date as Dimension.

Plz help.

tHanks

Re: Wrong Financial Year

rubenmarin — Mon, 16 Mar 2015 12:38:31 GMT

Hi Nikhil, try using floor on dates:

'Q'& Ceil(if(Month(Floor(CreateDate)) > 10 , Month(Floor(CreateDate)) - 10 , Month(Floor(CreateDate))+2)/3.0)

Re: Wrong Financial Year

nikhilgarg — Mon, 16 Mar 2015 12:43:32 GMT

Hey,

THankx but this also doesnot help. In the image i ahve attached as you can see, One date with Month of april showing Q2 and othe showing Q3. And also Dec Date showing Q1.

Re: Wrong Financial Year

Anonymous — Mon, 16 Mar 2015 12:47:48 GMT

Because there are 30 days in april not 31.

Thanks,

Re: Wrong Financial Year

rubenmarin — Mon, 16 Mar 2015 12:48:01 GMT

Hi, that date doesn't exists, april has 30 days. I think QV is converting to May-01.

Re: Wrong Financial Year

nikhilgarg — Mon, 16 Mar 2015 12:53:08 GMT

lol , my mistake but what when ia m using following expr:

'Q'& Ceil(if(Month(CreateDate) > 10 , Month(CreateDate) - 10 , Month(CreateDate)+2)/3.0)

Then it means i want financial year to start with Oct so except Dec Date all other quarters are going wrong.

Re: Wrong Financial Year

nikhilgarg — Mon, 16 Mar 2015 12:53:40 GMT

lol , my mistake but what when ia m using following expr:

'Q'& Ceil(if(Month(CreateDate) > 10 , Month(CreateDate) - 10 , Month(CreateDate)+2)/3.0)

Then it means i want financial year to start with Oct so except Dec Date all other quarters are going wrong.

Re: Wrong Financial Year

Anonymous — Mon, 16 Mar 2015 12:56:51 GMT

if you want it to start from oct then change the expression to:

'Q'& Ceil(if(Month(CreateDate) > 9 , Month(CreateDate) - 9 , Month(CreateDate)+3)/3.0)