Re: For Next Loop Date YYYYMM - Qlik Community

MarcoRaymundoKeyrus · ‎2019-08-02

Hi!

I try this:

FOR dt = Date(myDate,'YYYYMM') TO Date(myDateEnd,'YYYYMM')

Any ideas?

Anil_Babu_Samineni · ‎2019-08-02

Perhaps this?

FOR dt = Num(Month(Date(myDate,'YYYYMM'))) TO Num(Month(Date(myDateEnd,'YYYYMM')))

NEXT

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

sunny_talwar · ‎2019-08-02

What exactly are you trying to do within the loop? May be you need while loop here?

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Count...

MarcoRaymundoKeyrus · ‎2019-08-02

I have two variables: myDate and myDateEnd, both date formated like 'YYYYMM'.
I need a loop between variables. Like this: 201901,201902,....,201912,202001.

The qlikview interpreted the variable like YYYYMMDD.
Example: 20190101,...201901231,...20200131

Brett_Bleess · ‎2019-08-22

Marco, try the following link:

https://community.qlik.com/t5/QlikView-Documents/Calendars/ta-p/1496392

If that is of no help, try the following and search on calendar etc...

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Hopefully something out there may help you here.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.