topic Re: Dt in QlikView

Dt

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi ALl

please find my QVW attached I have a table which has a field called Release

here i need to convert this into date format how do i do it ..

here it should be like 17.2 should be considered as feb 2017 .

17.4 Apr 2017

17.5 May 2017 ...and so on

can someone please help me on this

Chanty4u — Mon, 31 Jul 2017 06:59:47 GMT

Hi try to create a inline table

load * Inline [

release ,Build

17.1 ,jan2017

17.2,feb2017

17.3,mar2017

....

.....

];

like above till dec2017 and do left join the main table with release column .

HTH

Chanty

tresB — Mon, 31 Jul 2017 07:00:36 GMT

Try like:

Load

Date(Date#(Release, 'YY.MM'), 'MMM YYYY') as NewDate

Kushal_Chawda — Mon, 31 Jul 2017 07:02:01 GMT

=monthname(Date#(DateField,'YY.M')) as MonthYear

prat1507 — Mon, 31 Jul 2017 07:05:20 GMT

Use

Date:

LOAD Release, date(MakeDate('20'&SubField(Release,'.',1),SubField(Release,'.',2),01),'MMM-YY') as Release_new

FROM

(ooxml, embedded labels, table is Sheet2);

smilingjohn — Mon, 31 Jul 2017 07:10:20 GMT

Hi Kushal

I did it as you said it is not converting properly ...Its consider jan and oct for 17.10

where as it should be oct only for 17.10

Kushal_Chawda — Mon, 31 Jul 2017 07:16:07 GMT

try below

monthname(Date#(DateField,'YY.MM')) as MonthYear

monthname(date#(subfield(DateField,'.',1) & num(subfield(DateField,'.',2),'00'),'YY.MM')) as MonthYear