Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think you will require to use set analysis in your expression. May be something like this:
{<DateField = {"$(='<=' & Date(Max(DateField), 'YourDateFieldFormat'))"}>}
Hi Sunny,
thanks for the extremely quick answer.
I will try asap and let you know!
regards,
Cristiano
Not a problem. Take your time and let us know if you continue to have trouble.
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