Calander script

[Ankit1988]

I have data in Excel file. In this dataset there is  field like "Month of code" in this field data is look like (oct'21)

So how to create calander script using mention field "Month of code"

Plz suggest idea.

Thanks in advance.

[brunobertels]

hi 

May be this 

replace this part '(octchr(39)21)' by the name of your field :

makedate('2023', // to create year 2023

month( // to get the number oh month here 10
date#( // to interpret text to date

subfield( // to take only month part here Oct parameter is 1
replace( // to supress character "(" and ")" and "'""
replace(
replace('(octchr(39)21)','chr(39)',' '),'(',''),')','')
,' ',1),'MMM'))

,

subfield( // to take only day part here 21 parameter is 2
replace( // to supress character "(" and ")" and "'""
replace(
replace('(octchr(39)21)','chr(39)',' '),'(',''),')','')
,' ',2)
)

[rwunderlich]

How about this to read the month. And then build a calendar off the Month field.

Date(Date#([Month of Code] '(MMM''YY)')) as Month

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[Ankit1988]

Thanks 

[Ankit1988]

Thanks understand