topic current month to 6 month data in Qlik Automate

current month to 6 month data

inam — Fri, 20 Oct 2023 10:18:27 GMT

Hello Everyone

I Have a column Month1 in this field

Aug 2023
Sep 2023
Oct 2023
Nov 2023
Dec 2023
Jan 2024
Feb 2024

i want current month to 6 month data for example current month is Oct-2023 so i want

Oct 2023
Nov 2023
Dec 2023
Jan 2024
Feb 2024

Mar-2024(if present in month1 column).

i am using below code but not getting answer.

=Sum({<MONTH1={"$(=Date(AddMonths(Today(),6),'MMM YYYY'))"}>} [Invoiced amount (no VAT)])

Mark_Little — Fri, 20 Oct 2023 10:23:35 GMT

That would be looking for data 6 months a head. try

Sum({<MONTH1={"$(>=Date(AddMonths(Today(),-6),'MMM YYYY'))"}>} [Invoiced amount (no VAT)])

inam — Fri, 20 Oct 2023 10:40:15 GMT

Hello @Mark_Little Thanks For Reply

i have Tried This also but not getting value .... //Error in Calculated dimension.

Mark_Little — Fri, 20 Oct 2023 11:05:29 GMT

Sorry,

try this

Sum({<MONTH1={">=$(=Date(AddMonths(Today(),-6),'MMM YYYY'))"}>} [Invoiced amount (no VAT)])