Help my data to limt on the user fed date . Please help .

[prahlad_infy]

Helo Seniours ,

I want to show only those data in my table which is of last week to the date selected by me plus next week data

last week data-UserFeddate-Nextweek data .

Thank you in advancing .

[isingh30]

You have to specify some date range. Like, start & end date in your expression.

Like this - ('>=' & '01/01/2010' & '<=' & '31/12/2012') it's just a sample syntax.

Thank you!

[ashishbhuyekar]

Are you doing any aggregration on top of these date selection? if yes, the i would suggest to go ahead with set expression using something like this, below expression is for the previous week -

=SUM({<Week = {">=$(=Max(Week(Selected date))-1)"}>} Sales)

[prahlad_infy]

I use varibale vDateselected to accept date from user and i want to fetch all the sales and date which happened 14 days earlier to this date plus 14 days later to this date

can you share expression with use of this variablea

[prahlad_infy]

‌ sureshqv‌ . Please help Sirs

[Chanty4u]

you want to display last 7days and next 7 days sales ?

[tresesco]

Try like:

Sum({<DateE={">=$(=Date(vDateselected-14)) <=$(=Date(vDateselected+14))"}>}Sales)

[prahlad_infy]

two different reqrimnt Sir

1) last 14 days and next 14 days

2) for ex if the  week of date selected by user is 3 then

                   sale of 3 week plus sale of 1&2 week plus sale of 4&5 week

[prahlad_infy]

thank Sir ..

Reaal requrment is below

1) last 14 days and next 14 days

2) for ex if the  week of date selected by user is 3 then

                   sale of 3 week plus sale of 1&2 week plus sale of 4&5 week

Sorry for mine weak english

[prahlad_infy]

Sir , your expression

Sum({<DateE={">=$(=Date(vDateselected-14)) <=$(=Date(vDateselected+14))"}>}Sales)

is pulling sales data for year 2017 as well

but  user date is 19/1/2018 so

as per your exp its should to pull data from date range 5 jan 18 to 2 feb 2018