Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Custom Calendar with posting periods

Hi All.

I need to build a calendar to resemble the SAP Posting Periods as follows :

SAP Calendar is in the format bellow :

Fiscal Year Variant  | Year | Calendar Month |  Calendar Day | Posting Period | Year Shift |

----------------------------------------------------------------------------------------------------------------------------

    Z1                         | 2014 |     1                       |      22                |        1                 |       0          |

    Z1                         | 2014 |     2                       |      21                |        2                 |       0          |

    Z1                         | 2014 |     3                       |      24                |        3                 |       0          |

    Z1                         | 2014 |     4                       |      23                |        4                 |       0          |

     .

     .

     .

   Z1                          | 2014 |     12                     |      22                |        1 2              |       +1        |   Year change

   Z1                          | 2015 |     1                       |      23                |        1                 |       0          |

   Z1                          | 2015 |     2                       |      23                |        2                 |       0          |

and so on.

I am trying to build a Calendar as follows :

fYearPosting PerDateMonth
2013123 Dec 2013 (period starts on 23 Dec 2013)Dec
2014101 Jan 2014Jan
2104102 Jan 2014Jan
...............................................................
2014223 Jan 2014 (new posting period starts)

Jan

2014224 Jan 2014Jan
2014225 Jan 2014Jan
.................................................
2014221 Feb 2014 (Posting period ends)Feb
2014322 Feb 2014Feb
2014323 Feb 2014Feb
..................................................................
20141222 Dec 2014Dec
2014123 Dec 2014 (New Posting period starts)Dec
.................................................................
2015101 Jan 2015 (year change)Jan
2015102 Jan 2015Jan

    Has anyone done anything similar ? Thanks in advance.

 

7 Replies

Re: Custom Calendar with posting periods

Load the calendar from SAP if possible. If that's not an option then create the calendar in an excel file and then load the excel file into qlikview. You will waste a lot more time if you're trying to create a script to generate such a calendar.


talk is cheap, supply exceeds demand
Not applicable

Re: Custom Calendar with posting periods

Hi Gysbert.

The SAP Table provides different data. I need to build the Calendar to reflect the different Posting Periods and Year Change. I found a script that calculates Pay Periods but still different from what I'm trying to achieve.

The Excel option is viable but with a lot of data entry.

Re: Custom Calendar with posting periods

Maybe like attached qvw.


talk is cheap, supply exceeds demand
Not applicable

Re: Custom Calendar with posting periods

Thanks Gilbert. It is getting closer. The only problem remaining is that the first posting period starts on the 23 Dec 2013 and ends on the 22 Jan 2014 and this period is flagged as PP 1.

Re: Custom Calendar with posting periods

No problem Shimano. The PP 1 is new to me. I didn't see that mentioned anywhere in your post. Can your explain what you expect?


talk is cheap, supply exceeds demand
Not applicable

Re: Custom Calendar with posting periods

PP 1 is the Posting Period (12 in total for each fiscal year. The hard part is that as you can see, the first posting period starts on the 23 Dec 2013 and finishes on the 22 of Jan 2014. Same happens when changing year from 2014 to 2015.

Re: Custom Calendar with posting periods

So you want the string 'PP' in front of the period numbers?


talk is cheap, supply exceeds demand
Community Browser