topic Re: How to separate Date and Month in QlikView

How to separate Date and Month

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

Hi All

I have data as below i would like to separate them like to have only Month(Jul,May,Oct,Sep etc ) and year(2015 and 2016)

Company:

LOAD Field,

[Jul-Sep 2015],

[May-Aug 2015],

[Oct-Dec 2015],

[Jan-Mar 2016]

from

C:\Users..........

Thanks

Re: How to separate Date and Month

tresB — Fri, 20 Jul 2018 10:34:02 GMT

Are these dates, names of fields, or values of a field? Could you share a sample data set and expected output?

Re: How to separate Date and Month

mandilicious — Fri, 20 Jul 2018 10:58:26 GMT

Hi Tresesco

This are values of a field my Expected output it must be separated like below

Month

Jan

Sep

May

Aug

Year

2015

2016

Re: How to separate Date and Month

tresB — Fri, 20 Jul 2018 11:07:23 GMT

Could you explain the real scenario with sample data with few more fields? If you have a value " [Jul-Sep 2015]", do you really want three separate line items out of it?

Re: How to separate Date and Month

ishanbhatt — Fri, 20 Jul 2018 11:39:17 GMT

Hi Dorlane,

Try to load data using Cross Table functionality and then use Subfield, Keepchar or left function to create Month and Year fields.

Re: How to separate Date and Month

mandilicious — Fri, 20 Jul 2018 13:04:06 GMT

Hi Tresesco B

Yes i actually need three separate line items out of it?

I have attached how my data look likes.

Thanks