Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
This is for Qlikview
Already posted in the correct forum, Thank you though for your reply
May be like this
Date(DateField + ValueLoop(0, 105, 7))
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))
Hello Sunny,
It worked
Thanks for this solution
Please don't start a topic twice.
I have rejected the other topic and am moving this topic.