topic Issue with Datefield in QlikView

Issue with Datefield

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a date field, 'YR_MTH_KEY' in my source table which is in below format:

201601

201602

201603

201604

201605

201606

201607

201608

201609

But in my chart I want to show it in a more meaningful way like 'MMM-YY' or something like that:

But I'm not able to change my format.

I gave the exp as Date(MonthStart(Date#(YR_MTH_KEY, 'YYYYMM'))), I got some junk value. Any idea how I should give my expression for the date field.

Re: Issue with Datefield

Anonymous — Mon, 10 Oct 2016 18:53:17 GMT

Date((Date#(YR_MTH_KEY, 'YYYYMM')))

(Date#(YR_MTH_KEY, 'YYYYMM')

Re: Issue with Datefield

sunny_talwar — Mon, 10 Oct 2016 18:53:49 GMT

Strange it did not work, but you did not provide MMM-YY to it? Not sure this will work, but try this:

Date(MonthStart(Date#(YR_MTH_KEY, 'YYYYMM')), 'MMM-YY')

Re: Issue with Datefield

Mon, 10 Oct 2016 19:21:45 GMT

Its returning junk values like:

Mar-91

Apr-94,

Apr-97,

May-00

Jun-03

Jan-40

Re: Issue with Datefield

Mon, 10 Oct 2016 19:21:52 GMT

Its returning junk values like:

Mar-91

Apr-94,

Apr-97,

May-00

Jun-03

Jan-40

Re: Issue with Datefield

rupamjyotidas — Mon, 10 Oct 2016 19:26:23 GMT

are those values format are in text or numbers, if in Numbers the above equations would work.

Re: Issue with Datefield

vishsaggi — Mon, 10 Oct 2016 19:29:10 GMT

May be trythis?

LOAD Date(MakeDate(Left(YRMonthKey,4), Right(YRMonthKey,2)), 'YYYYMM') AS YrMonthKey;

LOAD * INLINE [

YRMonthKey

201601

201602

201603

201604

201605

201606

201607

201608

201609

];

Re: Issue with Datefield

sunny_talwar — Mon, 10 Oct 2016 19:44:53 GMT

Will you be able to share your application, I am amazed its doing this