Discussion board where members can get started with Qlik Sense.
I have a column with dates. There is a separate date filter. I want to show Max Date from dates column based on the date selected in the filter.
If the user select 31-DEC-2017 then it restrict the dates till 31-DEC-2017 and show the maximum date from first day till 31-Dec-2017.
If the user select 30-NOV-2017 then it restrict the dates till 30-NOV-2017 and show the maximum date from first day till 30-NOV-2017.
Suppose Date is in vDate and dates column is plan_start_date.
if the user select 30-NOV-2017; the max date will also be 30-NOV-2017.
The condition is way simpler than "restricting the dates from the start to the 30-NOV-2017.. since the max date is in fact 30-NOV-2017)
Maybe I've missed understood some things
I've in fact misread.. there is 2 seperate date fields
it's double quotes and not quotes (please refer to this Quotes in Set Analysis )+ u've ommited the $(=urMeasure)
Thanks for the correction. I have edited that now. Must be an off day for me and wrote the expression in a hurry. Generally i am the one who ask people to refer the same document.