
Contributor
2023-03-08
06:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Labels (15)
Labels
1,084 Views
1 Reply


MVP
2023-03-08
06:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
