topic Re: To display YTD data by using filter pane in App Development

To display YTD data by using filter pane

sindhurasivakoti12 — Wed, 19 Dec 2018 19:26:29 GMT

I want to select particular year and month using filter pane. I want to display data by selecting year,month simultaneously and display data for YTD. I want to get data of both Jan and Feb while I select Feb in filter pane.Thanks in advance

Re: To display YTD data by using filter pane

sunny_talwar — Wed, 19 Dec 2018 19:30:24 GMT

May be try an expression like this

Count({<OrderYear, OrderMonth, OrderDate = {"$(='>=' & Date(YearStart(Max(OrderDate)), 'YYYY-MM-DD') & '<=' & Date(Max(OrderDate), 'YYYY-MM-DD'))"}>} Sales)

Re: To display YTD data by using filter pane

sindhurasivakoti12 — Thu, 20 Dec 2018 10:39:58 GMT

Yeah.It worked. But it is for measures i.e we are displaying count . But I need to pass date as parameter and show the data.Is it possible??Thanks in advance.

Re: To display YTD data by using filter pane

sunny_talwar — Thu, 20 Dec 2018 11:59:57 GMT

I am not sure I follow... do you have a sample you can share?

Re: To display YTD data by using filter pane

sindhurasivakoti12 — Thu, 20 Dec 2018 12:09:04 GMT

In the screenshot, I have written the measure as suggested by you,but it is passing numeric values to expression which is measure i.e

count({<OrderYear, OrderMonth,
OrderDate = {"$(='>=' & Date(YearStart(Max(OrderDate)), 'YYYY-MM-DD') & '<=' & Date(Max(OrderDate), 'YYYY-MM-DD'))"}>}Sales)

But here I want to pass date as parameter for expression.Is it possible??

Re: To display YTD data by using filter pane

sunny_talwar — Thu, 20 Dec 2018 12:12:26 GMT

So, you want to Count the Date instead of Sales?

Re: To display YTD data by using filter pane

manoranjan3359 — Thu, 20 Dec 2018 13:54:34 GMT

Yes exactly.

Re: To display YTD data by using filter pane

sunny_talwar — Thu, 20 Dec 2018 13:56:58 GMT

Then change Sales to Date...

Count({<OrderYear, OrderMonth,
OrderDate = {"$(='>=' & Date(YearStart(Max(OrderDate)), 'YYYY-MM-DD') & '<=' & Date(Max(OrderDate), 'YYYY-MM-DD'))"}>} OrderDate)

Re: To display YTD data by using filter pane

sindhurasivakoti12 — Thu, 20 Dec 2018 14:08:19 GMT

In the below screenshot,I have selected 2018 Aug,but I need to get data from Jan to Aug i.e YTD . But the data for August is displaying.

Re: To display YTD data by using filter pane

sunny_talwar — Thu, 20 Dec 2018 14:14:08 GMT

I have no idea what you are trying to do my friend. Would you be able to share a sample qvf and let me know what you want to see as the final output?