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: 
Somakaka_Moabi
Contributor
Contributor

How to find a list of dates between two dates

Hi Team, I am battling with solving this problem of finding all the dates between two dates in Qlik sense. 
for example, if we have a DateA and DateB , I want Qlik Sense to give me all the dates that are between DateA and DateB

1 Reply
Or
MVP
MVP

At the front end, ValueLoop(DateA, DateB-DateA, 1) or something similar.

On the backend, something along the lines of

Load Date(DateA + IterNo() - 1) as Date

From SomeTable

While IterNo() <= DateB-DateA