topic Re: Hai in QlikView

Split year and month

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

I have attache my file.I need to spilt as year and month,also month should be in text format.please clear my dbts

Re: Hai

kaushiknsolanki — Mon, 07 Nov 2016 17:46:09 GMT

You can try this.

Load Period,

Year(Makedate(Left(Period,4),Right(Period,2))) as Year,

Month(Makedate(Left(Period,4),Right(Period,2))) as Month

From Xyz;

Regards,

Kaushik Solanki

Re: Hai

Anil_Babu_Samineni — Mon, 07 Nov 2016 17:50:44 GMT

Try This too

Table1:

Load Period From Source;

Left Join(Table1)

Load Period,

Left(Period,4) as Year,

Right(Period,2) as Month

Resident Table1;

Load Period,

Year(Period,'YYYY') as Year,

Month(Period,'Mmm') as Month

From source ;

Re: Hai

antoniotiman — Mon, 07 Nov 2016 19:08:14 GMT

Hi,

LOAD *,

Year(Date#(Period,'YYYYMM')) as Year,

Month(Date#(Period,'YYYYMM')) as Month

From Table;

Month is Dual Field (Text and Number)

Regards,

Antonio

Re: Hai

Anonymous — Tue, 08 Nov 2016 04:18:00 GMT

Thanks..Its worked.

Re: Hai

Anonymous — Tue, 08 Nov 2016 05:16:27 GMT

Year(Date#(Period,'YYYYMM')) as Year,

Month(Date#(Period,'YYYYMM')) as Month

In this,What is the meaning of '#'.My view is fetch the value.am i right?

Re: Hai

oknotsen — Tue, 08 Nov 2016 12:02:50 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .