How to maximum/minimum value from the current selection date to previous 52 weeks

[#1]

Hi,

when I select a date/month column, I need a text box which displays the maximum price from the selected date until previous 52 weeks(1 year) .

Similarly I need the minimum price from the selected date to last 52 weeks .

How do I achieve this?

[Anonymous]

Hi Rekha,

Can you explain more about your problem?

And it will be good if you can share sample data.

Thanks,

Laxmi

[Anonymous]

Hola,

let vEnd=today();

let vStart=today()-365;

expression 1 is max(Date={">=$(=Date(vStart))<=$(=Date(vEnd))"}>}price)

expression 2 is min(same as above)

HTH

[#4]

Hi Ravi,

am getting an error for the set analysis expression.could you help me out

[PradeepReddy]

use the '$' symbol before the variable..

max(Date={">=$(=Date($(vStart)))<=$(=Date($(vEnd)))"}>}price)

[#6 · Accepted solution]

Thanks Pradeep and Ravi.

I was able to correct the expression ,below is the correct expression:

=max({<Date={">=$(=Date($(vStart)))<=$(=DT_KEY($(vEnd)))"}>}price)