topic Generate dates in the script in QlikView

Generate dates in the script

ericdelaqua — Sat, 16 Nov 2024 04:28:17 GMT

Hello,

I have the following data in the script :

Type	CurrentTripDate
Travel	12/02/2019

from the backend I need to output a table in the format below. I need hep generating the table.

pradosh_thakur — Wed, 13 Feb 2019 03:45:05 GMT

First make sure your dates are in date format and not string

What is the logic for the first date, please mention that, for the output you mentioned try below

if(rowno()=1,DATE#('2019/01/31','YYYY/MM/DD'), date(monthend(addmonths(peek(Last12monthends),-1)),'YYYY/MM/DD')) as Last12monthends

jonathandienst — Wed, 13 Feb 2019 05:38:25 GMT

Something like this?

Data:
LOAD Type, 
	CurrentTripDate
	...
FROM ...

Join(Data)
LOAD Date(Floor(MonthEnd(Today(), -1 - RowNo()))) as Last12MonthEnds
Autogenerate 12;