Using date in QlikView

Thu, 09 Jun 2011 22:00:15 GMT

Hello all,

I start to create some code in QlikView, but i need help in order to manipulate date.

I want to create a link between an api and my program.The api ask me some information (a date) in this format 070308 'DDMMYY'

I want to know if I could do something like that

For a=date to dateFin

Load ....

....

FROM 'NAME OF THE WEBSITE' + $(a)

Does Qlikview is able to manipulate date like this?

Does am i able to do something like that and what is the syntax. (I've made some research but have'nt found it).

For example :

For a=10-03-2011 to 09-06-2011

test=Format(10-03-2011,DDMMYY)

Load ........

FROM 'MY WEBSITE' + $(test)

Anonymous — Thu, 09 Jun 2011 23:30:33 GMT

Hey Trash (that feels wrong )

Here's a sample script that shows you how you can run a range of values through a for loop based on dates.

let vStart= num(date#('2011-03-01', 'YYYY-MM-DD'));

let vEnd= num(date#('2011-05-31', 'YYYY-MM-DD'));

for a = $(vStart) to $(vEnd)

Load

$(a) as Value,

Date($(a), 'DDMMYY') as Date

autogenerate 1;

next

topic Using date in QlikView in QlikView