topic Re: Quarter Creation in QlikView

Quarter Creation

akpofureenughwu — Tue, 07 Jun 2016 21:38:10 GMT

How do I create a quarter period in my script. Please find the attached file for clarity. Thanks

sunny_talwar — Tue, 07 Jun 2016 21:52:04 GMT

This:

NoConcatenate

LOAD [S/N],

[Supply Field],

If(Len(Trim(Region)) = 0, Peek('Region'), Region) as Region,

Supplier,

Type,

[Daily Average],

[Annual Cumm],

Date(Num#(Date)) as Date,

Month(Num#(Date)) as Month,

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

MonthName(Num#(Date)) as MonthYear,

Year(Num#(Date)) as Year,

Value

akpofureenughwu — Tue, 07 Jun 2016 22:05:05 GMT

Thanks Man. How about the day of the month in the script?

sunny_talwar — Tue, 07 Jun 2016 22:07:38 GMT

You can use Day() function for that: