LYTD 2022

[Luisanabria]

Hi All

I would like to know how can l show in a comparation YTD vs LYTD, the same month of my actual year, for example, if l show JAN to SEP 2023, l want my measure SALES LYTD 2022 show the same period JAN to SEP

Actually l have this:
Sum({<Year={$(=Max(Year)-1)}, [Categoria 1 DetFac]={"COMERCIAL", "ACCESORIOS"}>} [Monto Neto Mn])

But this show me Last year's cumulative.  I have filters....but what I don't want is to use filters.

I asked ChatGPT but the examples it gave me didnt work!


Thanks

[ElisaF]

Hi @Luisanabria,

You have many solutions.

The technical solution depends on the fields (time dimensions: Year, Month, Period, Transaction date, etc.) that you have in DataMart - into Fact Table or Calendar Table.
See the following links below:

https://community.qlik.com/t5/App-Development/YTD-compared-to-LYTD/td-p/2021071

https://community.qlik.com/t5/New-to-Qlik-Sense/YTD-LYTD-MTD-and-LMTD/td-p/1659464

https://community.qlik.com/t5/Member-Articles/QlikView-App-Simple-Year-To-Date-Example-Set-Analysis/...