Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
RimDataAnalyst
Contributor III
Contributor III

Generate dates in Visual

 

Hello,

I want to generate a date range between two dates in visual (I use the iterNO function in the Loading script) but here I need the same function but put it as a dimension in a graph

Labels (4)
5 Replies
menta
Partner - Creator II
Partner - Creator II

You can use 

 

ValueLoop(from [, to [, step ]])

Valueloop('01/01/2022','31/12/2022',1)

https://help.qlik.com/it-IT/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Sy...

RimDataAnalyst
Contributor III
Contributor III
Author

thank you for your answer but i want to generate dates from a start date and end date (variables) 

Valueloop generate dates between two constant 

menta
Partner - Creator II
Partner - Creator II

you can use variables also in valueloop

RimDataAnalyst
Contributor III
Contributor III
Author

this error appears when i put my variables : 

RimDataAnalyst_0-1671546624601.png

 

menta
Partner - Creator II
Partner - Creator II

It works for me

 

= ValueLoop(vStart,Date(vStart+5),1)