topic Re: Convert sql to qv-script in QlikView

Convert sql to qv-script

Tue, 15 Oct 2013 08:32:31 GMT

Hi all.

I need help to convert this sql to qv-script:

Convert(integer,substring(Month,1,4) + substring (Month,6,7) ) as YearMonthNum,

Where "Month" looks like "2009-08".

Thanks in advance.

Peter_Cammaert — Tue, 15 Oct 2013 08:37:14 GMT

left(Month, 4)*100 + right(Month, 2) as YearMonthNum

Best,

Peter

Peter_Cammaert — Fri, 18 Oct 2013 08:57:02 GMT

Did it work?

If so, please mark an answer to close this discussion. That makes it easier for us to track unanswered questions. Thanks.

Peter

hic — Mon, 21 Oct 2013 08:18:17 GMT

I would instead use

Date(Date#(Month,'YYYY-MM'),'YYYY-MM')

Then you will get a proper dual value - a value with both a numeric (date serial number) and textual part.

HIC

jagan — Mon, 21 Oct 2013 08:26:27 GMT

Hi,

Try like this

=Date(Date#(Month, 'YYYY-MM'),'YYYY-MM')) AS

=Date(MakeDate(Left(Month, 4), Right(Month, 2)), 'YYYY-MM')

Hope this helps you.

Regards,

Jagan.