topic Re: Please Find My Sample Data......I Want Script.... in QlikView

Please Find My Sample Data......I Want Script....

gireesh1216 — Mon, 22 Feb 2016 12:06:32 GMT

Hello....My Sample Data Is...

I Want Output Like This....

oknotsen — Mon, 22 Feb 2016 13:26:55 GMT

Use a date() function:

date(fieldname, 'MMM-YYYY')

sunny_talwar — Mon, 22 Feb 2016 13:30:12 GMT

May be try this:

LOAD Empid,

Date(Date#(Date, 'DD/MM/YYYY'), 'MMM-YYYY') as Date

FROM Source;

Sample Script:

SET DateFormat='DD/MM/YYYY';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

Table:

LOAD Empid,

Date(Date, 'MMM-YYYY') as DateOption1,

MonthName(Date) as DateOption2

FROM

[https://community.qlik.com/thread/206460]

(html, codepage is 1252, embedded labels, table is @1);

Clever_Anjos — Mon, 22 Feb 2016 13:38:31 GMT

LOAD

EmpId,

Date,

Date(MonthStart(Date#(Date,'DD/MM/YYYY')),'MMM/YYYY') as Month

FROM yourdata;

gireesh1216 — Mon, 22 Feb 2016 14:18:51 GMT

Tq All

oknotsen — Mon, 22 Feb 2016 14:23:42 GMT

Please flag the Correct Answer and optional Helpful Answers. Thank you.