topic Re: find month year in Qlik Automate

find month year

inam — Fri, 20 Oct 2023 06:40:55 GMT

Hello Community,

I have column "Check_in" in this date feild

05-09-2023
22-08-2023
28-10-2023
10-12-2023
04-11-2023
03-10-2023
30-09-2023
12-11-2023
20-10-2023
14-08-2023
18-01-2024
01-11-2023
26-08-2023
04-01-2024
01-02-2024
14-08-2023
15-08-2023
12-11-2023
12-11-2023
25-08-2023
05-09-2023
22-08-2023
28-10-2023
10-12-2023
04-11-2023
03-10-2023
30-09-2023
12-11-2023
20-10-2023
14-08-2023
18-01-2024
01-11-2023
26-08-2023
04-01-2024
01-02-2024
14-08-2023
15-08-2023
12-11-2023
12-11-2023
25-08-2023
22-09-2023

i want month year column like jan-2023,feb-2023,march-2023, jan-2024 etc

expected output below :-

jan-2023

feb-2023

mar-2023

apr-2023

may-2023

jun-2023

jul-2023

aug-2023

sep-2023

oct-2023

nov-2023

dec-2023

jan-2024

feb-2024

mar-2024

Re: find month year

Rahul_Athavale — Fri, 20 Oct 2023 06:53:11 GMT

Hi,
You can use Monthname function.
you can use below expression:-
Monthname(FieldName)

Re: find month year

inam — Fri, 20 Oct 2023 06:59:29 GMT

Thanks @Rahul_Athavale 😊 working fine now

Re: find month year

inam — Fri, 20 Oct 2023 10:02:50 GMT

Hello @Rahul_Athavale

I have one another doubt .

i am taking month feild in dimension but i want current month to 6 month only

=Sum({<MONTH1={"$(=Date(AddMonths(Today(),6),'MMM YYYY'))"}>} [Invoiced amount (no VAT)]) i am using this but its not work .please can you help me

Re: find month year

Rahul_Athavale — Fri, 20 Oct 2023 10:45:33 GMT

if you want sum of [Invoiced amount (no VAT)] for previous six months only then

Sum({<New_Date={">=$(=date(AddMonths(Max(Date_Field),-6),'DD/MM/YYYY'))<=$(=date(Max(Date_Field),'DD/MM/YYYY'))"}>}salary)

Re: find month year

mikemiler — Tue, 24 Oct 2023 09:37:47 GMT

Looking to the future with mobile app development services, we can expect further integration of AI and machine learning for predictive analytics, the adoption of 5G for real-time data sharing, and a focus on sustainable, eco-friendly warehousing practices.