topic Re: hi in QlikView

hi

Mon, 11 Aug 2014 07:46:09 GMT

i have a date column and want to extract quarter information from this. The date is is the YYYYMMDD format.

thanks

Re: hi

tresB — Mon, 11 Aug 2014 07:52:07 GMT

Try like:

Load

'Q' & Ceil(Month(Date#(YourDateField, 'YYYYMMDD'))/3) as Quarter

Re: hi

MK_QSL — Mon, 11 Aug 2014 07:54:44 GMT

Create below line in your master calendar or below the Date field...

'Q'&Ceil(Month(Date#(YourDateField,'YYYYMMDD'))/3) as Quarter

Re: hi

Mon, 11 Aug 2014 08:30:24 GMT

Thanks, its working fine.

I have one more requirement. I want set Nov as my first month so that if I select Q1, I should see, Nov, Dec and Jan month information.

Regards,

Viresh

Re: hi

Mon, 11 Aug 2014 08:31:44 GMT

Its working fine, Thank You.

I have one more requirement. How to set Nov as my first month. So if i select Q1, i should see, Nov, Dec and Jan info.

Regards,

Viresh

Re: hi

aveeeeeee7en — Mon, 11 Aug 2014 08:37:23 GMT

Try this to create Quarter:

'Q'&Ceil(Num(Month(AddMonths(Date,-10)))/3) as [Fiscal Quarter]

It will give you the result:

Q1 - Nov, Dec, Jan

Q2 - Feb, Mar, Apr

Q3 - May, Jun, Jul

Q4 - Aug, Sep, Oct

See this Post:

http://community.qlik.com/thread/108327

Regards

Aviral Nag

Re: hi

tresB — Mon, 11 Aug 2014 08:44:01 GMT

Then you have to recalculate your month field preferably using preceding load like:

Load

'Q' & Ceil(fMonth/3) as Quarter;

Load

Mod(Month(Date#(YourDateField, 'YYYYMMDD')) -11, 12)+1 as fMonth,

From <>;

Re: hi

Mon, 11 Aug 2014 08:53:12 GMT

I tried this but in the Fmonth list box I am getting numbers from 1 to 12. Is it possible to show the month name instead of numbers?

Re: hi

aveeeeeee7en — Mon, 11 Aug 2014 08:55:29 GMT

Have you tried my logic posted above.

It will work.

See this:

Try this to create Quarter:

'Q'&Ceil(Num(Month(AddMonths(Date,-10)))/3) as [Fiscal Quarter]

It will give you the result:

Q1 - Nov, Dec, Jan

Q2 - Feb, Mar, Apr

Q3 - May, Jun, Jul

Q4 - Aug, Sep, Oct

See this Post:

http://community.qlik.com/thread/108327

Regards

Aviral Nag

Re: hi

Mon, 11 Aug 2014 09:00:40 GMT

I got it, its working fine.

thanks guys.

Re: hi

Mon, 11 Aug 2014 09:01:00 GMT

Hey thank you so much. Its working fine.. ☺

Re: hi

hannan_t — Mon, 11 Aug 2014 09:01:48 GMT

Try this:

date(makedate(left(Date_Field,4),mid(Date_Field,5,2),Right(Date_Field,2)),'DD-MM-YYYY')

It will convert YYYYMMDD into DD-MM-YYYY and after that try applying ceil function.

Re: hi

tresB — Mon, 11 Aug 2014 09:04:20 GMT

Try like:

Load *,

'Q' & Ceil(fMonth/3) as Quarter;

Load

Mod(Month(Date#(YourDateField, 'YYYYMMDD')) -11, 12)+1 as fMonth,

Month(Date#(YourDateField, 'YYYYMMDD')) as Month

From <>;

Here if you select Nov from Month field, it will associate '1' in the fMonth field.