Solved: Month - Qlik Community

qlikview979 · ‎2016-06-20

Hi Experts,

I have in date in Excel like

STARTDATE ENDDATE

27/03/2016 31/05/2016

I need output like

maniram23 · ‎2016-06-20

Hi,

T1:

LOAD

date(start_date,'YYYY_MMM') as start_date,

date(End_date,'YYYY_MMM') as End_date,

company_name

FROM

[........xlsx]

(ooxml, embedded labels, table is Sheet1);

LOAD Addmonths(start_date,iterno()-1) as start_date,

company_name

Resident T1

WHILE AddMonths(start_date,iterno()-1) <= End_date;

DROP Table T1;

View solution in original post

qlikview979 · ‎2016-06-20

Output like this

2016_mar

2016_apr

2016_may

PrashantSangle · ‎2016-06-20

Hi,

using those 2 field you want create one field????

> use master calendar

For that formating

> use date(dateField,'YYYY_MMM')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous · ‎2016-06-20

Why not check this?

The Date Function

yadav_anil782 · ‎2016-06-20

PLZ TRY THIS

LOAD

date,

date(date,'YYYY-MMM') AS Date

FROM

(qvd);

muthukumar77 · ‎2016-06-20

Hi,

Can you send me a sample QVW file?

Muthukumar Pandiyan

qlikview979 · ‎2016-06-20

Hi Anil,

Please check my source& output . I don't have April Month in source ,but i want April month also.

Regards,

Mahesh.

qlikview979 · ‎2016-06-20

Hi

please find the attached file

jonathandienst · ‎2016-06-20

Load like this:

LOAD

Date(MonthStart(STARTDATE), 'yyyy-MMM') as STARTDATE,

Date(MonthStart(ENDDATE), 'yyyy-MMM') as ENDDATE,

...

I would use MonthStart or MonthEnd to ensure a unique value for each month. Otherwise you could land up with multiple dates formatted as (for example) "2016-Jun", so they look the same, but have different underlying values (1 Jun, 2 Jun etc).

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

qlikview979 · ‎2016-06-20

Hi Jonathan,

Please check my above attached Qvw.

Regards,

Mahesh.

Month

Related Topics