Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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)