topic Re: For Next Loop Date YYYYMM in QlikView

For Next Loop Date YYYYMM

MarcoRaymundoKeyrus — Fri, 02 Aug 2019 16:39:59 GMT

Hi!

I try this:

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

But, the Qlik generate day by day, i need month by month.

Any ideas?

Re: For Next Loop Date YYYYMM

Anil_Babu_Samineni — Fri, 02 Aug 2019 16:53:57 GMT

Perhaps this?

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

NEXT

Re: For Next Loop Date YYYYMM

sunny_talwar — Fri, 02 Aug 2019 16:57:37 GMT

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/CounterFunctions/IterNo.htm

Re: For Next Loop Date YYYYMM

MarcoRaymundoKeyrus — Fri, 02 Aug 2019 18:58:31 GMT

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

Re: For Next Loop Date YYYYMM

Brett_Bleess — Thu, 22 Aug 2019 21:45:53 GMT

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