how can I use a date field as an "until to" filter

[#1]

Hi all,

I am quite new to Qlik Sense and this is my first question in the community.

I checked around but was not able to find an answer.

I have a table with a date field (actually it is a numeric in format "yyyymmdd") , and I would like

to let the user that select a specific calendar date to get all the related records that are equal or lesser than

that date.

Is there a way of achieving that?

thanks in advance and regards,

Cristiano

[sunny_talwar]

I think you will require to use set analysis in your expression. May be something like this:

{<DateField = {"$(='<=' & Date(Max(DateField), 'YourDateFieldFormat'))"}>}

[#3]

Hi Sunny,

thanks for the extremely quick answer.

I will try asap and let you know!

regards,

Cristiano

[sunny_talwar]

Not a problem. Take your time and let us know if you continue to have trouble.

[#5]

Sorry for late answer,

my interest was in getting the related records as filtered , not just the sum or similar.

I tried with the example but it did not work , so in the end I had to link the records date to the calendar.

thanks for your help.

regards,

Cristiano