topic Re: One MOnth out of two date in QlikView

One MOnth out of two date

smilingjohn — Fri, 20 Nov 2020 18:58:42 GMT

Hi Expertise,

I have come across a 2 scenarion where i need to get month filed out of two dates .

1. Register Date and Update Date Here i should how can i achive this during load script ? my both dates formats are as below .

2. I have string something like this "IN drew care203 ///_BED the23 " and i need to show only BED from this .

Thanks IN Advance

Re: One MOnth out of two date

QFabian — Mon, 09 Nov 2020 15:40:36 GMT

Hi, try something like this :

Load
month([Register Date]) as [Register Month],
month([Update Date]) as [Update Month],
subfield(subfield(yourraretext, '///_', 2), ' ', 1) as [yourextractedtext]
from your source;

Re: One MOnth out of two date

smilingjohn — Mon, 09 Nov 2020 15:59:12 GMT

@QFabian I dont want seprate Months, I want to have one month from both the dates . considering equal dates .

And also the Subfield dosnot work for me ,becuase BED can even come in the first middle or last .

Thanks

Re: One MOnth out of two date

QFabian — Mon, 09 Nov 2020 16:18:04 GMT

something like this ?

Load
if(monthname([Register Date]) = monthname([Update Date]), month([Update Date])) as [Month],
if(findoneof(yourraretext, 'BED')>0, 'BED') as [yourextractedtext]
from your source;