topic Re: Restricting Values in App Development

Restricting Values

naveen409 — Mon, 20 Dec 2021 21:38:40 GMT

Hi All,

I'm Having Data from APR-2016 to Till date.I created a Filter for MonthYear.

I'm showing Rolling 12 Months Data.But I want data from 2017 to Till data.

How to restrict 2016?

Your Suggestions Appreciated.

Thanks

Regards,

Nani

Re: Restricting Values

gayathri_nagara — Wed, 17 Apr 2019 10:48:37 GMT

Hi Naveen,
Create a variable and restrict the data from 2017 to Till Date.

Re: Restricting Values

miskinmaz — Wed, 17 Apr 2019 10:59:40 GMT

Use set analysis in the expression to exclude the year.

Re: Restricting Values

naveen409 — Wed, 17 Apr 2019 11:13:02 GMT

Can You give me some Idea about this?

Re: Restricting Values

HirisH_V7 — Wed, 17 Apr 2019 11:14:20 GMT

If you wan to restrict data in script then:
Put where condition like this,
Where Year(Date)>2017;

If in UI Level means,
Sum({<Date={">31-12-2017"}>}Sales)

Re: Restricting Values

naveen409 — Wed, 17 Apr 2019 11:17:57 GMT

Is there any approach?

Actually I tried the below
Ex : Sum({1<Year={">2016"}>}Revenue)

Re: Restricting Values

naveen409 — Wed, 17 Apr 2019 11:23:43 GMT

Yes HarishV,
If I did the set analysis, I can't Select any other Values from the filter. That approach is Static Not Dynamic.

If I will be Selecting APR-2018 It has to Show up to May-2017
In the same manner if I Will be Selecting APR-2017 it will be Show May-2016 Correct. Rolling 12 Months.

In the Rolling 12 Months I don't want to see 2016 data. Hope you understand the requirement.

Thanks for the Reply

Re: Restricting Values

HirisH_V7 — Thu, 18 Apr 2019 07:23:18 GMT

Check this,

=Sum({<Year-={"<2017"}>}Revenue)