Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amithmurali
Partner - Creator II
Partner - Creator II

Qlikview not recognising Date

Hi guys,

I have a table with the date format like this,

Period_id
201501
201502
201503
201504
201505

How can i make qlikview understand this type of format.

Its giving me no values when i try Year(Period_id).

1 Solution

Accepted Solutions
amithmurali
Partner - Creator II
Partner - Creator II
Author

Thanks , it worked. i used it like this.

MonthEnd(Date#(PERIOD_ID,'YYYYMM')) as KPIDate,

View solution in original post

6 Replies
maleksafa
Specialist
Specialist

try this one

=year(date(date#('201501','YYYYMM'),'MMM-YYYY'))

qlikmsg4u
Specialist
Specialist

Hi Amith,

Try like this

=Year(Date#(Period_id,'YYYYMM'))

robert_mika
Master III
Master III

=makedate(left('201501',4),right('201501',2),1)

amithmurali
Partner - Creator II
Partner - Creator II
Author

Thanks , it worked. i used it like this.

MonthEnd(Date#(PERIOD_ID,'YYYYMM')) as KPIDate,

qlikmsg4u
Specialist
Specialist

Amith Try this

=MonthEnd(Date(Date#(PERIOD_ID,'YYYYMM')))

jonathandienst
Partner - Champion III
Partner - Champion III

Load the date fields like this:

LOAD Period_id,

  Date#(Period_id, 'YYYYMM') As Period,

  Year(Date#(Period_id, 'YYYYMM')) As Year,

  ...

Now you can use Period as a normal date field and Year as the year field.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein