two-month aggregation dynamically

[lotitolo]

Good morning, everyone,

I am looking to create a new dimension date where the month of August will become the month of July.

The idea is to make an aggregation of these two months dynamically.

I already created a script via Tableau some time ago, but I don't really know how to do it under Qlik Sense. I looked at the customs calendar without really finding an answer.

Here is my old script generated under Tableau if it helps you:

(if MONTH([Date]) = 7 then DATEADD('month',1,[Date]) else[Date] end)

ELSE[Date]

END

Thank you very much,

LotitoLo

[Vegar · Accepted solution]

Try

if (MONTH([Date]) = 7 , addmonths('Date',1) ,
[Date])

[lotitolo]

It works perfectly, I'll just fix the layout:) thank you very much!
Finally the syntax is not so different as on Tableau