topic Re: Week and Month key format in QlikView

Week and Month key format

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

I want to convert my week id and month id into a correct readable format.

May be I will do this is edit script.

my Week Id is like '20161201' and I want it as '01/02/2016'

and my Month Id is '201602' , I want this as 'Feb 2016'

Is this possible ?

Or any other way around ?

Please help!!!

sunny_talwar — Wed, 28 Sep 2016 18:32:44 GMT

May be like this:

For Week Id

Date(Date#([Week Id], 'YYYYMMDD'), 'DD/MM/YYYY') as [Week Id],

For Month Id

Date(MonthStart(Date#([Month Id], 'YYYYMM')), 'MMM YYYY') as [Month Id],

MonthName(Date#([Month Id], 'YYYYMM')) as [Month Id],

sampada0810 — Tue, 04 Oct 2016 09:09:25 GMT

Thanks for your reply.

It helped me!!