topic Re: Datepicker in App Development

Datepicker

abhijeetmoon07 — Wed, 19 Oct 2022 07:41:26 GMT

whenever i select a date on which i dont have any entry in my data it shows all the data from my dataset.

suppose i want to find no of employee left the organization on a particular date suppose i select 1 jan 2022 but in my data no one left on this date but when i select this date it shows count of all the records i am having in my dataset.

Re: Datepicker

Mark_Little — Thu, 27 Oct 2022 06:41:02 GMT

HI @abhijeetmoon07

What is your set analysis and how is your data connect to the calendar? I would expect it to return null when no values are on that date.

Re: Datepicker

abhijeetmoon07 — Mon, 28 Nov 2022 12:39:32 GMT

There is no Set analysis just use sum(sales) and when you select any two dates from that date picker it should show sales between those two dates and if there is no sales between those two dates then it should show null or zero sales.