topic Make quarter date from script attached in QlikView

Make quarter date from script attached

rcorcoran — Mon, 28 Sep 2015 11:39:17 GMT

Hi below is the part of the script where I have made a date YearMonth from ReferredMM and ReferredYYYY. I also need to make a quarter date field which I was trying below but not getting very far with.

Any help would be greatly appreciated

FACTS:
LOAD ActualValue,
ReferredMM,
ReferredYYYY,
MonthName(Date(makedate(ReferredYYYY,ReferredMM))) as YearMonth,
// 'Q' &Ceil(MonthName(Date(makedate(ReferredYYYY,(ReferredMM/3))))) as Quarter,

Re: Make quarter date from script attached

sunny_talwar — Mon, 28 Sep 2015 11:59:09 GMT

Try this for quarter:

'Q' & Ceil(Month(MakeDate(RefferedYYYY, ReferredMM, 1))/3) as Quarter

Update: Just realized that I missed a parenthesis

Re: Make quarter date from script attached

rcorcoran — Mon, 28 Sep 2015 12:34:45 GMT

Hi Sunny T

Thanks for answering but it didn't work maybe because ReferredMM and ReferredYYYY are not date fields?

Thanks

Re: Make quarter date from script attached

sunny_talwar — Mon, 28 Sep 2015 12:36:00 GMT

Can you share the data within those two fields?

Re: Make quarter date from script attached

rcorcoran — Mon, 28 Sep 2015 12:41:51 GMT

Yes see above where I have made the month and year into amalgamated date

Re: Make quarter date from script attached

jonathandienst — Mon, 28 Sep 2015 12:48:53 GMT

Assuming ReferredMM is a text month:

Ceil(Month(Date#(ReferredYYYY & Left(ReferredMM, 3), 'YYYYMMM')) / 3) As Quarter

Re: Make quarter date from script attached

sasiparupudi1 — Mon, 28 Sep 2015 12:53:22 GMT

Please try

='Q' & Ceil(Month(MakeDate(ReferredYYYY, ReferredMM, 1))/3)

hth

Sasi

Re: Make quarter date from script attached

rcorcoran — Mon, 28 Sep 2015 14:59:52 GMT

Thank you so much this has worked perfectly.

Rhona

Re: Make quarter date from script attached

rcorcoran — Mon, 28 Sep 2015 15:00:52 GMT

Thanks Sunny also right. Thanks for your help