Last year today or yesterday

[HKN1]

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

[MatheusC]

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

[HKN1]

Hi, @MatheusC 

I wish I wanted it if it was so easy 😞

It contains much more than Today(), my writing

Thanks.

[MatheusC]

@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 

[HKN1]

very helpful.

Thank you very much,

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

[Mark_Little]

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?