Month-Year Script help!

[amit_saini]

Hi Folks,

Always want to show only last 12 months based on below expression in list box:

=Month ([GSE by KT plant.Month]) & '-' & Year ([GSE by KT plant.Month])

Please suggest ???

Thanks,

AS

[Anonymous]

why you are doing this: =Month ([GSE by KT plant.Month]) & '-' & Year ([GSE by KT plant.Month])??

Instead of this use monthname(DateField) at script, you will get same result....

see this:

Show rolling 12 Months only for last 12 months.

[Anonymous]

see this as well:

Set Analysis for Rolling Periods

https://community.qlik.com/message/385963?_ga=1.242312897.238313988.1442987432#385963

Rolling last 12 months | Qlik Community

[senpradip007]

Why do you not use MonthYear() function?

[amit_saini]

To get Month and Year from [GSE by KT plant.Month]

Actually we are not having any date field for this application

Thanks,
AS

[Kushal_Chawda]

what is values in [GSE by KT plant.Month] field?

[amit_saini]

Thanks,
AS

[its_anandrjs]

Use Makedate or monthname function if you have only Year or month field like

=MonthName(MakeDate(Year([GSE by KT plant.Month]),Month([GSE by KT plant.Month])))

And try

=Monthname( Addmonths(MonthName(MakeDate(Year([GSE by KT plant.Month]),Month([GSE by KT plant.Month]))),-12))

Regards

Anand

[amit_saini]

Hi Anand,

=Monthname( Addmonths(MonthName(MakeDate(Year([GSE by KT plant.Month]),Month([GSE by KT plant.Month]))),-12))

This one is not working!

Thanks,
AS

[amit_saini]

Just want to show Nov 2014 till  Oct 2015 inside list box from the above example.

Thanks

AS