topic Re: Load script make of two fields one in QlikView

Load script make of two fields one

Thu, 21 Aug 2014 12:28:29 GMT

Hello together,

i Need your help. I have two fields mont and year. How I get this two fields in one field with load script?

Thanks

Jörn

tresB — Thu, 21 Aug 2014 12:32:06 GMT

Try like:

Load

MakeDate(YearField, MonthField) as Date // This will work if month is numerical

Date(Date#(YearField&MonthField&'1', 'YYYYMMMD')) as Date // If month is like - jan. feb...

PrashantSangle — Thu, 21 Aug 2014 12:33:30 GMT

Hi,

Try this,

Month &'-'& Year as New_Month_Year

Regards,

ashfaq_haseeb — Thu, 21 Aug 2014 12:34:27 GMT

Hi,

try below

Load

Day,

Month,

Year,

Date,

Month&'-'&Year as MonthYear

from test.qvd;

Regards

ASHFAQ

hannan_t — Thu, 21 Aug 2014 12:36:14 GMT

Try this in your script :

MonthField&'-'&YearField as MonthYear

Result will be something like this:

Aug-2014

MayilVahanan — Thu, 21 Aug 2014 12:42:34 GMT

Its based on your requirement.

MakeDate(YearField, MonthField, 01) as Date Gives FirstDayofMonth respective year.

YearField&'-'&MonthField as YearMonth Gives ex: 2014-08 or 2014-Aug

MonthField&'-'&YearField as MonthYear Gives ex: 08-2014 or Aug-2014

Hope it helps