This content has been marked as final. Show 2 replies
I am having trouble calculating/scripting the cumulative days at a specific depth in QlikView. I currently have an sql table which pulls in the date and the depth at that specific date. But instead of the date as a dimension I want a count of days up to that specific point.
An aggr(count(Days), Dim) brings in a total count of days which does not work for my analysis.
3/1/2016 | 3/2/2016 | 3/3/2016 | 3/4/2016 | 3/5/2016 | days
0 | 1 | 2 | 3 | 4 | 5 | days
Can someone please advise?