topic Re: LINEST_M function set analysis help in QlikView

LINEST_M function set analysis help

saumyashah90 — Thu, 24 Oct 2013 10:04:26 GMT

Hi All,

I have

=if(LINEST_M(Metric_Value,Dt)>=0,LINEST_M(Metric_Value,Dt))

I have StartDate and EndDate Variable and i want above expression with start date and enddate in it.

How can i do that.

Dt is my Date column

Re: LINEST_M function set analysis help

saumyashah90 — Thu, 24 Oct 2013 10:12:42 GMT

any 1?

Re: LINEST_M function set analysis help

swuehl — Thu, 24 Oct 2013 10:14:03 GMT

Try something along these lines

LINEST_M({<Dt = {">=$(StartDate)<=$(EndDate)"}>} Metric_Value,Dt)

assuming that your variables are formatted to match the format of your Dt field values.

Re: LINEST_M function set analysis help

saumyashah90 — Thu, 24 Oct 2013 10:16:16 GMT

Yeah i tried this before also,

But when i change dates in calendar,

out put doesnt change

Re: LINEST_M function set analysis help

swuehl — Thu, 24 Oct 2013 10:27:20 GMT

I assume it's just a formatting issue, i.e. the format of your variables.

Try

LINEST_M({<Dt = {">=$(=Date(StartDate,FORMATCODE))<=$(=Date(EndDate,FORMATCODE))"}>} Metric_Value,Dt)

where you need to replace FORMATCODE with an appropriate format code to match format of field Dt, e.g. 'YYYY-MM-DD', or post a small sample that demonstrates your issue.