rolling months in backend

[antonybi]

Hi All,

I need to derive a field(period) rolling 3months and rolling 6months in qlik script level because I have to use in front end.

I've created two tables in the data model(data and master calendar).

Please help me out in this.

[Vegar · Accepted solution]

I would recommend you to take a look at HICs blog post about The As-Of Table in order to sort you Rolling 3 and 6 months needs.