Date wise creating the flag in single column 1 month, Previous month, 3 months, MTD, QTD, YTD ...

[Ramu_i]

Hi All,

According to date wise creating the flags for 1 Month, 3 Month, 6 Months, Previous Month, YTD, PYTD, MTD, PMTD, QTD, PQTD, WTD, PWTD , Last 10 Weeks, Last 30 Weeks like that is there in One filter value and another filter is Monthyear, Week, Day.

Here creating two filters like Range and Date

Range is -1 Month, 3 Month, 6 Months, Previous Month, YTD, PYTD, MTD, PMTD, QTD, PQTD, WTD, PWTD , Last 10 Weeks, Last 30 Weeks

Date is -Monthyear, Week, Day

I have date filed as DD/MM/YYYY HH:MM:SS format.

In script side will derive the 1 Month, 3 Month, 6 Months, Previous Month, YTD, PYTD, MTD, PMTD, QTD, PQTD, WTD, PWTD , Last 10 Weeks, Last 30 Weeks, Monthyear, Week, Day.

1 Month:

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

If current date is 25/11/2022 - 1 month is --- 25/11/2022 to 24/10/2022

If current date is 26/11/2022 - 1 month is --- 26/11/2022 to 25/10/2022 Like 1 Month

3 Months:

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

If current date is 25/11/2022 - 3 month is --- 25/11/2022 to 24/9/2022

If current date is 26/11/2022 - 3 month is --- 26/11/2022 to 25/9/2022 Like 3 Month

6 Month:

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

If current date is 25/11/2022 - 6 month is --- 25/11/2022 to 24/5/2022

If current date is 26/11/2022 - 6 month is --- 26/11/2022 to 25/5/2022 Like 6 Month

YOY:

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

is Jan to Till date and Previous year of Jan to Current date of Previous date.

Last 30 Weeks:

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

This week to Last 29 Weeks.

....

Thanks advance

Ram

Please help on this .

[Ramu_i]

Here creating two filters like Range and Date

Range is -1 Month, 3 Month, 6 Months, Previous Month, YTD, PYTD, MTD, PMTD, QTD, PQTD, WTD, PWTD , Last 10 Weeks, Last 30 Weeks

Date is -Monthyear, Week, Day

I have date filed as DD/MM/YYYY HH:MM:SS format.

In script side will derive the 1 Month, 3 Month, 6 Months, Previous Month, YTD, PYTD, MTD, PMTD, QTD, PQTD, WTD, PWTD , Last 10 Weeks, Last 30 Weeks, Monthyear, Week, Day.

1 Month:

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

If current date is 25/11/2022 - 1 month is --- 25/11/2022 to 24/10/2022

If current date is 26/11/2022 - 1 month is --- 26/11/2022 to 25/10/2022 Like 1 Month

3 Months:

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

If current date is 25/11/2022 - 3 month is --- 25/11/2022 to 24/9/2022

If current date is 26/11/2022 - 3 month is --- 26/11/2022 to 25/9/2022 Like 3 Month

6 Month:

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

If current date is 25/11/2022 - 6 month is --- 25/11/2022 to 24/5/2022

If current date is 26/11/2022 - 6 month is --- 26/11/2022 to 25/5/2022 Like 6 Month

YOY:

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

is Jan to Till date and Previous year of Jan to Current date of Previous date.

Last 30 Weeks:

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

This week to Last 29 Weeks.

....

Thanks advance

Ram

Please help on this .

[hic]

Take a look at https://community.qlik.com/t5/Design/The-As-Of-Table/ba-p/1466130. This method can certainly solve some of your requirements.

[vinieme12]

additional reference

https://community.qlik.com/t5/QlikView-Documents/Set-Analysis-for-certain-Point-in-Time/ta-p/1482626

[Ramu_i]

Hi Hic,

I need Two filters , One filter having range, another filter is date , 

Range is 1 month, previous month, MTD,QTD, WTD,YTD,PYTD, PMTD,PQTD, Last 20 weeks... these all are show in single filter,

Date is shows Month, Week, Day. here when select the month it will display the current month infor, week - current week, day means current day.

Thanks advance.

Ram

[Ramu_i]

Hi Vinieme12,

I need Two filters , One filter having range, another filter is date , 

Range is 1 month, previous month, MTD,QTD, WTD,YTD,PYTD, PMTD,PQTD, Last 20 weeks... these all are show in single filter,

Date is shows Month, Week, Day. here when select the month it will display the current month infor, week - current week, day means current day.

Thanks advance.

Ram

[vinieme12]

Refer this article

https://community.qlik.com/t5/Member-Articles/Period-Presets-Compare-Periods-on-the-fly/ta-p/1486371https://community.qlik.com/t5/Member-Articles/Period-Presets-Compare-Periods-on-the-fly/ta-p/1486371

You can create a period field as below

[Ramu_i]

Hi Vinieme12,

Thanks for the solution.

Ram

[Ramu_i]

Hi Vinieme12,

Thanks for giving the solution.

Ram

[Ramu_i]

Hi Hic,

Thanks for the solution.

Ram

[vinieme12 · Accepted solution]

please close the thread by marking a response as a solution