topic if to set analysis in QlikView

if to set analysis

Tue, 22 Feb 2011 15:22:24 GMT

Is there a way to convert this to set analysis?

if((ADate-90<=BDate), aggr(max(total <KEY> FieldC),KEY),0)

if to set analysis

Tue, 22 Feb 2011 16:06:58 GMT

Hi,

Try something like this:

aggr(max({$<BDate = {'>= ADate-90'}>} total <KEY> FieldC), KEY)

if to set analysis

Tue, 22 Feb 2011 16:11:56 GMT

Hi there,

it should be something like this:

aggr(max({$<BDate={'>=$(ADate)-90'}>} total <KEY> FieldC),KEY)

Hope this helps

Regards!

if to set analysis

Tue, 22 Feb 2011 17:04:34 GMT

what if I change it to

sum(if(ADate-90<=BDate), aggr(max(total <KEY> FieldC),KEY),0)

Would i put the set after sum, aggr, or max?

if to set analysis

Tue, 22 Feb 2011 17:07:51 GMT

Oh I also have a variable which i have been using after the sum as $(variable)

thanks!!

if to set analysis

Tue, 22 Feb 2011 17:30:45 GMT

You have to put the set analysis inside sum and max.

can you give an example of how you use your variable?

if to set analysis

Tue, 22 Feb 2011 18:38:24 GMT

sum($(variable)aggr(max({$<BDate={'>=$(ADate)-90'}>} total <KEY> FieldC),KEY)

Here is my current expression, but if I change the 90 to 60 or 30 it does not do anything to the numbers I am getting. Is that due to my expression or most likely something else?

if to set analysis

Tue, 22 Feb 2011 20:14:32 GMT

I haven't prove it, but try:

sum($(variable) aggr(max({$<BDate={">=$(#=date(ADate-90)"}>} total <KEY> FieldC),KEY)

What is the value of the variable?