Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
Thanks , it worked. i used it like this.
MonthEnd(Date#(PERIOD_ID,'YYYYMM')) as KPIDate,
try this one
=year(date(date#('201501','YYYYMM'),'MMM-YYYY'))
Hi Amith,
Try like this
=Year(Date#(Period_id,'YYYYMM'))
=makedate(left('201501',4),right('201501',2),1)
Thanks , it worked. i used it like this.
MonthEnd(Date#(PERIOD_ID,'YYYYMM')) as KPIDate,
Amith Try this
=MonthEnd(Date(Date#(PERIOD_ID,'YYYYMM')))
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.