topic Re: Derived calculation issue in QlikView

Derived calculation issue

shyamcharan — Tue, 05 Aug 2014 01:38:38 GMT

Hi Experts,

I am trying to use the below formula to get slope in a text box.

=Linest_m(Total Aggr( rangesum(Above(Total sum(X),0,RowNo(Total))),$(test)), $(test))

test:

$(test)=$(CostChartStartDate)+Y*7

Here Y is Age, so basically i am adding age to the start date and multiplying with 7 because the age units is weeks.

to derive into days i have to multiply age * 7 days and add this to start date.

CostChartStartDate:

$(CostChartStartDate) = 01/02/2009

In the slope formula when i give a normal date field from database it works fine but when i use this derived formula it does not work.

Any idea please help. It is same with many calculations where it does not work for the variables that have the formulas.

Thanks in advance.

Shyam.

Re: Derived calculation issue

Tue, 05 Aug 2014 02:31:10 GMT

Hi,

Usually data are a bit annoying... Have you try to format the variable in date?

$(test)= date( $(CostChartStartDate)+Y*7 ,'DD/MM/YYYY')

Re: Derived calculation issue

shyamcharan — Tue, 05 Aug 2014 02:40:06 GMT

Hi Filippo,

Thanks for your response.

Yes I have tried that and no luck. not sure what i am missing.

Thanks in advance.

Shyam

Re: Derived calculation issue

shyamcharan — Tue, 05 Aug 2014 04:06:20 GMT

Hi,

Any help here please. Just to get the variables work is killing me.

Now I have used a different approach. Rather adding the age to date i just used the Age field because I just need slope and the chart what i have designed works but now getting this work in text box is having issue

nothing shows up.

Re: Derived calculation issue

tresB — Tue, 05 Aug 2014 04:33:53 GMT

Try like:

=Date(Date#($(CostChartStartDate), 'DD/MM/YYYY')+Y*7)

Re: Derived calculation issue

shyamcharan — Wed, 06 Aug 2014 04:31:48 GMT

Hi all,

Thank you very much for your suggestions.

However, I had no luck with your suggestions. It looks like the linest_m function does not go well with the $() variables.

Appreicate any other suggestions or help on this.

Thanks in advance.

Regards,

Shyam

Re: Re: Derived calculation issue

shyamcharan — Wed, 13 Aug 2014 06:38:42 GMT

Hi Experts,

Here is what i am able to get for more information. Attached is the QVW file that i am working and now i wanted to display the slope of the lines in a text box or in some sort of table.

I used the below formula but it break when i used the multiplication operator like *(i guess) for my report scenario

Linest_m(Total Aggr(Y2,X2), X2)

Can some one please help me get the slopes for this

I am struggling with this since 2 weeks and its been embrasing to me a little bit

I appreciate your help on this.

Thanks in advance.

-Shyam