Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Generating Dates

Get a copy of the QV Cookbook from

http://robwunderlich.com/downloads/

Take a look at the example "Generate date (calendar) table.". That includes some typical patterns for generating dates. Dates are an integer. Incrementing a date by seven days is done by adding 7. There are also functions like WeekStart() that will identify the first day of the week.

-Rob

Not applicable

Re: Generating Dates

Hi Guys,

              I will let you know what my actual requirement is...

              I have columns like Job Date and PM Interval

             Now I need to generate dates like 1st Jan 2009,10th Jan 2009,20th Jan 2009,....31st Dec 2009.

             Dates have to be generated at an interval of 10 Days.I can do this date generation now.

            I need to show a bubble chart which has these above generated dates in the x-axis and Pm Interval

            in the y-axis.

            Now, Suppose we have the foll data of Job Date and PM Interval 

            Job Date       PmInterval

            2-Jan-2009      30

            4-Jan-2009      40

         

           Now there will be two bubbles between 1st Jan 2009 and 10th Jan 2009 and at intersection point

           of PMInterval 30 and 40.

           Please guide me with this.

         Regards

         Navin.G

Not applicable

Re: Generating Dates

Hi Guys,

              I will let you know what my actual requirement is...

              I have columns like Job Date and PM Interval

             Now I need to generate dates like 1st Jan 2009,10th Jan 2009,20th Jan 2009,....31st Dec 2009.

             Dates have to be generated at an interval of 10 Days.I can do this date generation now.

            I need to show a bubble chart which has these above generated dates in the x-axis and Pm Interval

            in the y-axis.

            Now, Suppose we have the foll data of Job Date and PM Interval 

            Job Date       PmInterval

            2-Jan-2009      30

            4-Jan-2009      40

         

           Now there will be two bubbles between 1st Jan 2009 and 10th Jan 2009 and at intersection point

           of PMInterval 30 and 40.

           Please guide me with this.Let me know if you have any issues.

         Regards

         Navin.G

Highlighted
Not applicable

Re: Generating Dates

Hi,

Please see the attached sample can generate every 10th day in a year.

Cheers.

Community Browser