Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

micheledenardi
Valued Contributor

Fiscal Master Calendar Flags

Hi guys,

my fiscal period starts on July, so July is my first fiscal month, and i want to create a simple fiscal master calendar with some flags like below:

Fiscal Period: Calendar Period + 6 Months

FL_CY: Current Fiscal Year

FL_LY: Last Fiscal Year

FL_LY-1: Last Fiscal Year -1

FL_CYTM: Current Fiscal Year to Month

FL_LYTM: Last Fiscal Year to Month

FL_LYTM-1: Last Fiscal Year -1 to Month


This is the expected result:

How can i achieve this by using an elegant way ?

2018-05-15 17_22_38-Cartel1 - Excel.png

Community Browser