Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Do Loop in a chart function

Is it possible to create a calculated dimension of dates using Do loop in a chart

Example,

1st Row can be Jan/01/2017

2nd Row : Jan 8 2017

3rd Row : Jan 15 2017

.

.

.

.

.

for next 15 instances. Gap of 7 days between each instance.

1 Solution

Accepted Solutions
sunny_talwar

May be like this

Date(DateField + ValueLoop(0, 105, 7))

View solution in original post

7 Replies
oknotsen
Master III
Master III

Since you are posting this in the wrong forum, can you please clarify for which product you are asking this question?

Once we know, we can move it to the correct forum and hopefully get you a good answer.

May you live in interesting times!
Not applicable
Author

This is for Qlikview

Not applicable
Author

Already posted in the correct forum, Thank you though for your reply

sunny_talwar

May be like this

Date(DateField + ValueLoop(0, 105, 7))

Not applicable
Author

Hello Sunny,

Thank you for the reply, but it is not working on Dates. Please check if my syntax is correct..

=Date('01/01/2017' + ValueLoop(0,105,7))

Not applicable
Author

Hello Sunny,

It worked

Thanks for this solution

oknotsen
Master III
Master III

Please don't start a topic twice.

I have rejected the other topic and am moving this topic.

May you live in interesting times!