topic Re: filter date for the last 2 dates in Qlik NPrinting

filter date for the last 2 dates

ioannagr — Tue, 19 Oct 2021 12:20:26 GMT

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 — Tue, 19 Oct 2021 13:15:16 GMT

Hi,

Best Regards,

Ruggero

ioannagr — Tue, 19 Oct 2021 14:02:50 GMT

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 — Tue, 19 Oct 2021 21:34:46 GMT

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 — Tue, 19 Oct 2021 21:36:19 GMT

more regarding filters here: