topic Re: Last year today or yesterday in App Development

Last year today or yesterday

HKN1 — Fri, 06 Oct 2023 12:44:20 GMT

Hello,

I would like to present the data below in the table format below today or yesterday. but it's not working.

Can you help me, grace?

thanks

Re: Last year today or yesterday

MatheusC — Fri, 06 Oct 2023 13:08:40 GMT

Hi, @HKN1
for the same date today() from the previous year use addmonths(today(),-12)

Re: Last year today or yesterday

HKN1 — Fri, 06 Oct 2023 13:13:46 GMT

Hi, @MatheusC

I wish I wanted it if it was so easy 😞

It contains much more than Today(), my writing

Thanks.

Re: Last year today or yesterday

MatheusC — Fri, 06 Oct 2023 13:27:51 GMT

@Hi, @HKN1  if there are several comparisons it is not possible to work with the filters leaving only the expression
max(year) and max(year)-1,
I believe that the best solution is to work according to the calendar,

watch this post
https://community.qlik.com/t5/Design/Year-over-Year-Comparisons/ba-p/1462927

Re: Last year today or yesterday

HKN1 — Thu, 19 Oct 2023 13:42:24 GMT

very helpful.

Thank you very much,

I have been working for a long time. I will report the result.

Re: Last year today or yesterday

Mark_Little — Thu, 19 Oct 2023 13:51:36 GMT

I would probably be looking to create flags in script to do this.

If you are not using the Date today how are you picking the date for this year and last year?