Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

scotly-victor
Contributor

Fiscal YTD ,QTD,MTD ,WTD

Hi Qilkers,

          Can anybody  help me to  achieve Fiscal YTD,QTD,MTD,WTD?

Tags (4)
2 Replies
MVP
MVP

Re: Fiscal YTD ,QTD,MTD ,WTD

You can create flags in the script to do this:

This provide the script to generate fiscal year calendar

Fiscal and Standard Calendar generation

For flags you can use the logic from here:

Creating A Master Calendar

Combine the two and you are good to go

reddys310
Honored Contributor II

Re: Fiscal YTD ,QTD,MTD ,WTD

Hi Scotly,

There are functions which will help you set flags for all of there in your master calender.

You can make use of these functions:

inYearToDate()     

inQuarterToDate()

inMonthToDate()

inWeekToDate()

Community Browser