topic Re: Make new fields after binary load of data model in QlikView

Make new fields after binary load of data model

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

Hi,

I am very new to QlikView. I would like to make a date field from a text field after binary load of a QVW, so that I can use it to calculate YTD or Rolling-12-month sales. The text field value is now showing such as 201611, 201612,etc, could anyone know how to make it to a "date" as one new field in the data model and then use it as a master calendar. Thanks.

Simon

Re: Make new fields after binary load of data model

MayilVahanan — Wed, 04 Jan 2017 04:14:43 GMT

Hi,

In Data model script itself, you can try like this

Date(Date#(DateFieldinText,'YYYYMM'),'YYYYMM') as Date

And then join with master calendar

Re: Make new fields after binary load of data model

Anonymous — Wed, 04 Jan 2017 04:46:18 GMT

The statement added as below where "AE.M_Date" is the text field name in the the ABC.qvw., but the "Date" not created. What should do to fix it?

Binary C:\ABC.qvw;

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='£#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='MM/DD/YY';

SET TimestampFormat='MM/DD/YY hh:mm:ss[.fff]';

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

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Load

Date(Date#(AE.M_Date,'YYYYMM'),'YYYYMM') as Date