topic Re: Month not reflects date in QlikView

Month not reflects date

nareshthavidishetty — Wed, 17 Feb 2016 09:05:35 GMT

Hi the user financial year is fro FEB to JAN

so i have created month start from FEB

but it doesn't reflects the date means if i click on FEB month it gives JAN data as below for your reference,

Re: Month not reflects date

renuka_sasikumar — Wed, 17 Feb 2016 09:15:08 GMT

First derive one variable

LET vFM = 2;

And then in your Load statement use this

Mod(If(Len(Num(Month(Date)))<2,0 & Num(Month(Date)),Num(Month(Date))) - $(vFM), 12)+1 as fMonth

This will give you financial year starting from Feb.

Regards,

Renuka S

Re: Month not reflects date

renuka_sasikumar — Wed, 17 Feb 2016 09:19:44 GMT

Check this attachment which will be useful for you.

Its a Master Calendar.

Regards,

Renuka S

Re: Month not reflects date

nareshthavidishetty — Wed, 17 Feb 2016 09:20:24 GMT

Thanks Renuka ,but what about the quarter

Re: Month not reflects date

renuka_sasikumar — Wed, 17 Feb 2016 09:26:58 GMT

Most welcome Naresh.

Check in attachment everything you have in it.

Just use your field name instead of Date.

'Q' & Ceil((Mod(If(Len(Num(Month(Date)))<2,0 & Num(Month(Date)),Num(Month(Date))) - $(vFM), 12)+1)/3) as Quarter,

Year(Date) + If(If(Len(Num(Month(Date)))<2,0 & Num(Month(Date)),Num(Month(Date))) > =$(vFM), 1, 0)-1 as fYear,

Hope you got it

Re: Month not reflects date

sunny_talwar — Wed, 17 Feb 2016 09:31:35 GMT

Also look at the blog for tips to create fiscal calendar:

Fiscal Year

Fiscal and Standard Calendar generation

Re: Month not reflects date

nareshthavidishetty — Wed, 17 Feb 2016 09:39:54 GMT

Hi am getting months as 1,2,3,4,....12 i need to show month names 1=feb,2=mar,.....12=Jan

Re: Month not reflects date

sunny_talwar — Wed, 17 Feb 2016 09:42:21 GMT

Is it still not working based on Renuka's responses? Have you looked at the second link I shared. jagan‌ has provided the script to create a fiscal calendar. Try it out.

Re: Month not reflects date

renuka_sasikumar — Wed, 17 Feb 2016 09:43:42 GMT

Derive Month(Date) as MonthName along with the above expression.

If possible post your app.

Regards,

Renuka S

Re: Month not reflects date

senpradip007 — Wed, 17 Feb 2016 09:46:06 GMT

Have look at this.

Re: Month not reflects date

nareshthavidishetty — Wed, 17 Feb 2016 09:52:20 GMT

Hi am getting as below

to get month names i used month(date) but it gives only FEB and JAN month names

Re: Month not reflects date

renuka_sasikumar — Wed, 17 Feb 2016 10:02:05 GMT

Post you app