topic Re: How to maximum/minimum value from the current selection date to previous 52 weeks in QlikView

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

Thu, 19 Feb 2015 09:14:57 GMT

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 — Thu, 19 Feb 2015 09:18:21 GMT

Hi Rekha,

Can you explain more about your problem?

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

Thanks,

Laxmi

Anonymous — Thu, 19 Feb 2015 09:29:17 GMT

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

Thu, 19 Feb 2015 09:50:53 GMT

Hi Ravi,

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

PradeepReddy — Thu, 19 Feb 2015 10:08:06 GMT

use the '$' symbol before the variable..

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

Thu, 19 Feb 2015 11:48:03 GMT

Thanks Pradeep and Ravi.

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

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