Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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