topic Re: change QuarterYear To Date in QlikView

change QuarterYear To Date

mfikrirahmat — Wed, 10 May 2017 07:48:11 GMT

I have expenditure variable "Q4-2016", I want to change it to date 12/1/2016

sunny_talwar — Wed, 10 May 2017 09:17:50 GMT

May be like this

Date(MakeDate(Right(expenditure, 4), Num(Month(Date#(KeepChar(expenditure, '0123456789-), 'M-YYYY')))*3, 1))

PrashantSangle — Wed, 10 May 2017 09:26:37 GMT

Hi,

try like

=MakeDate(right('Q4-2016',4),right(left('Q4-2016',2),1)*3,1)

=MakeDate(right(expenditure,4),right(left(expenditure,2),1)*3,1)

Regards,

tresB — Wed, 10 May 2017 09:28:20 GMT

Or like (without any string function):

=MakeDate(Year(Date#('Q4-2016', 'QM-YYYY')),Month(Date#('Q4-2016', 'QM-YYYY'))*3)

Sergey_Shuklin — Wed, 10 May 2017 09:32:12 GMT

Hi, Mfikri!

Or like that:

date#(pick(match(left(expenditure,3),'Q1-','Q2-','Q3-','Q4-'),'3/1/','6/1/','9/1/','12/1/')&right(expenditure,4),'MM/DD/YYYY')

mfikrirahmat — Wed, 10 May 2017 09:37:39 GMT

It's Work , thank you so much