filter date for the last 2 dates

[ioannagr]

Hello everyone!

I want to filter my report with a filter to get data for only he last two days (max date, max date -1, max date -2).

I created this filter  which doesn't work with Advanced Search like : =([MyDate]>=max(date([MyDate])-2))

Do you perhaps know how I can do this?

[Ruggero_Piccoli]

Hi,

Did you already checked posts on similar topic? For example https://community.qlik.com/t5/Qlik-NPrinting-Discussions/date-filter-gives-error/td-p/1789718

Best Regards,

Ruggero

[ioannagr]

Hello, Ruggero,

yes I looked around but didn't find anything that worked for me.

Only when i did, evaluate :  max(MyDate), 

add value : max(MyDate)-1

add value: max(MyDate)-2

but i was/am  interested in handling that with an expression...  Anything i do with the form of one,ends up making no filtering at all to data.

[Lech_Miszkiewicz]

Have you tested your Advanced search syntax directly in Qlik Sense filterpane? That is the first thing to do! 

If your [MyDate] field is loaded to Qlik as a Date/Integer type either of below formulas will work without issues:

=[MyDate]>=$(=max([MyDate]) - 2)

=[MyDate]>=$(=max([MyDate] - 2))

cheers

Lech

[Lech_Miszkiewicz]

more regarding filters here:

https://nprintingadventures.com/category/nprinting/filters/