topic Re: How To Generate Date's Based on YYYYMM eg(201911) in QlikView

How To Generate Date's Based on YYYYMM eg(201911)

kalisetty-saite — Thu, 06 Feb 2020 10:25:27 GMT

Hi Guys your help will be appreciated I had Column called as Month which has the Year and Month Data as 201911

Now i need to generate all Dates for the Nov Month of 2019.

Re: How To Generate Date's Based on YYYYMM eg(201911)

StarinieriG — Thu, 06 Feb 2020 10:33:03 GMT

Hi,

try something like this

TABLE:
LOAD
Date#(date,'YYYYMM') AS date

from ...;

Inner Join
LOAD
date,
Date(MakeDate(Year(date),Month(date),1)+IterNo()-1) as DATE
Resident TABLE
While Month(MakeDate(Year(date),Month(date),1)+IterNo()-1)=Month(date);

Re: How To Generate Date's Based on YYYYMM eg(201911)

kalisetty-saite — Thu, 06 Feb 2020 10:57:28 GMT

Hi Thx For The Code i tried but it's not working app is getting hanged while refreshing can you share sample QVW

Thanks for ur response and support

Re: How To Generate Date's Based on YYYYMM eg(201911)

StarinieriG — Thu, 06 Feb 2020 11:11:57 GMT

Hi,

here the attached

Re: How To Generate Date's Based on YYYYMM eg(201911)

kalisetty-saite — Thu, 06 Feb 2020 11:54:03 GMT

Thanks StarinieriG Solution is working