How to show data starts on?

[qlikviewforum]

I am using the below expression to show the starting date of the data if the period goes back before the period starts. So the below expression worked perfectly.

If the data exists for the selected date then as per the selected date, date should be visible. What changes is required to achieve the 2nd requirement. Please help!

date(Min({<Period=>}Period), 'MM/DD/YYYY')

[qlikviewforum]

Thanks for your response.

I have already tried this but it is not working whenever the Period is selected in the dashboard. It is regarding '-' but it does works when there is a selection.

[qlikviewforum]

That's perfect. Thank you so much.

[qlikviewforum]

Sorry Jonathan I have misunderstood the requirement earlier so I am coming back on that.

I have input box to enter the Trending days, based on the value in the input box it displays data in the chart. for example if the input value is 10 then in the chart it display data for max(date) to last 10 days. if there is any date selected in the calendar then it displays it display 10 days data from selected date.

Imagine for a source if the 03/23/2015 and selected date range is 01/01/2015 to 12/31/2015 then expected output is 03/23/2015.

If the selected date range is 06/01/2014 to 07/01/2015 then expected output is 03/23/2015 since data is starting from 03/23/2015

If the selected data range is from 03/29/2015 to 03/29/2015 then expected output is 03/29/2015.

So if the date range goes back to 03/23/2015 then we should display 03/23/2015,

If the date range goes after 03/23/2015 then we should display the selected. i,e 03/29/2015 if the date range is 03/29/2015 to 03/29/2015

Hope the requirement is understandable. If not please let me know.