topic Re: Month Creation Using Two Fields in QlikView

Month Creation Using Two Fields

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

Hi ,

I have two fields FROM DATE & TO DATE. It is monthly data. I need to create month name field using these two dates

I need month name

dapostolopoylos — Fri, 15 Jun 2018 10:53:40 GMT

Use Month(FROM DATE) and Month(TO DATE)

wilsonwebb — Fri, 15 Jun 2018 12:56:46 GMT

HI Apoorva,

Use:

'TableName':

Load

Date(Month([FROM DATE]),'MMMM') as MonthFromName,

Date(Month([TO DATE]),'MMMM') as MonthToName

MarcoWedel — Fri, 15 Jun 2018 19:57:00 GMT

Can you post your expected result as well based on your sample data?

Anil_Babu_Samineni — Mon, 18 Jun 2018 05:53:22 GMT

I can think like this?

Table_Load:

Load [FROM DATE] as DateField From Table;

Join

Load [TO DATE] as DateField From Table;

Final:

NoConcatenate

Load DateField, Month(DateField) as Month Resident Table_Load:

Drop Table Table_Load;

Anonymous — Mon, 18 Jun 2018 10:35:34 GMT

give example using interval match

avinashelite — Mon, 18 Jun 2018 10:49:45 GMT

could you give the same output required ?

jyothish8807 — Mon, 18 Jun 2018 11:06:14 GMT

Hi Apoorva,

Try like this:

First create a master calendar using min(From Date) and Max(To Date) and Name it "Date" field.

Then:

Intervalmatch(Date)

Load distinct

[To Date],[From Date] resident <Yourtable>;

Br,