Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

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

4 Replies
MVP
MVP

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

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

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

Not applicable

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

Hi Sunny,

thanks for the extremely quick answer.

I will try asap and let you know!

regards,

Cristiano

MVP
MVP

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

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

Not applicable

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

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