topic Re: Month-Year Script help! in QlikView

Month-Year Script help!

amit_saini — Wed, 09 Dec 2015 05:54:51 GMT

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,

Re: Month-Year Script help!

Anonymous — Wed, 09 Dec 2015 06:10:51 GMT

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.

Re: Month-Year Script help!

Anonymous — Wed, 09 Dec 2015 06:13:00 GMT

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

Re: Month-Year Script help!

senpradip007 — Wed, 09 Dec 2015 06:16:31 GMT

Why do you not use MonthYear() function?

Re: Month-Year Script help!

amit_saini — Wed, 09 Dec 2015 06:16:34 GMT

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

Actually we are not having any date field for this application

Thanks,
AS

Re: Month-Year Script help!

Kushal_Chawda — Wed, 09 Dec 2015 06:22:26 GMT

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

Re: Month-Year Script help!

amit_saini — Wed, 09 Dec 2015 06:24:04 GMT

Thanks,
AS

Re: Month-Year Script help!

its_anandrjs — Wed, 09 Dec 2015 06:28:46 GMT

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

Re: Month-Year Script help!

amit_saini — Wed, 09 Dec 2015 06:32:57 GMT

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

Re: Month-Year Script help!

amit_saini — Wed, 09 Dec 2015 06:35:46 GMT

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

Thanks

Re: Month-Year Script help!

Kushal_Chawda — Wed, 09 Dec 2015 06:36:24 GMT

create the MonthYear Field as

monthname(date#([GSE by KT plant.Month],'MM-YY')) as MonthYear.

Now using this month year you will be able to do the set analysis

Re: Month-Year Script help!

its_anandrjs — Wed, 09 Dec 2015 06:38:51 GMT

Share any sample file only date field in which you have problem.

Regards

Anand

Re: Month-Year Script help!

tresB — Wed, 09 Dec 2015 06:42:08 GMT

=Aggr(If(Date#(MonthYear, 'DD-YY')>=$(=Max(Date#(MonthYear, 'DD-YY'),10)), MonthYear),MonthYear)

Change the fieldname to yours.

Re: Month-Year Script help!

amit_saini — Wed, 09 Dec 2015 06:46:31 GMT

PFA,

Re: Month-Year Script help!

tresB — Wed, 09 Dec 2015 06:52:19 GMT

=Aggr(If(Date#(Month_Year, 'MMM YYYY')>=$(=Max(Date#(Month_Year, 'MMM YYYY'),10)), Month_Year),Month_Year)

Re: Month-Year Script help!

amit_saini — Wed, 09 Dec 2015 07:04:24 GMT

Not idea why it's not working here.

Plz see the attachment.

Thanks,
AS

Re: Month-Year Script help!

tresB — Wed, 09 Dec 2015 07:44:52 GMT

Aggr(if([GSE by KT plant.Month]>='$(=Max([GSE by KT plant.Month],10))', [GSE by KT plant.Month]),[GSE by KT plant.Month])

Re: Month-Year Script help!

amit_saini — Wed, 09 Dec 2015 07:50:03 GMT

Thanks a lot