Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Next
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)
NEXT
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