topic Re: DATE ISSUE in QlikView

DATE ISSUE

sagaraperera — Fri, 19 Jun 2015 07:11:38 GMT

Dear all

how to make " 'MMM YYYY as TRANS_DATE," using the script given below

my Script

BCOD,

MONTH,

YEAR,

MONTH2,

CLA_CODE,

MONM,

GROSS_PREMIUM,

I previously used the script, Date(MONTH,'MMM YYYY') as TRANS_DATE.but the "TRANS_DATE" has not organized properly.

looking forward to a favorable reply.

SAGARA

MK_QSL — Fri, 19 Jun 2015 07:15:53 GMT

Date (MonthStart (TRANS_DATE),'MMM YYYY') as TRANS_DATE

Fri, 19 Jun 2015 07:18:04 GMT

Try this one,

Text(Date(Today(),'MMM YYYY')) as Trans_date

padmanabhan_ram — Fri, 19 Jun 2015 07:18:34 GMT

Hi Sagara,

Please try using the below code in the script while loading the dashboard.

Date#(FieldName,'MMM\YYYY') as FieldName

Date(FieldName,'MMM\YYYY') as FieldName

Date#(Date(FieldName,'MMM\YYYY'),'MMM\YYYY') as FieldName

Try the above codes one by one, check which one works for your format.

Regards,

Padmanabhan

jagan — Fri, 19 Jun 2015 07:21:55 GMT

Hi,

Try like this

LOAD

MakeDate(YEAR, MONTH) AS TRANS_DATE

FROM DataSource;

Regards,

Jagan.

gautik92 — Fri, 19 Jun 2015 07:24:49 GMT

Try this in Dimension Tab

=Date(TransactionDate,'MMM-YYYY')

Kushal_Chawda — Fri, 19 Jun 2015 07:28:36 GMT

Use monthname(FiledName) as TRANS_DATE