topic Re: Get fieldvalue In Chart in QlikView

Get fieldvalue In Chart

orital81 — Sun, 27 Nov 2011 10:01:03 GMT

Hi, I am working on Material Balance model.

My current goal is to develop a Forecast view of the Material.

I have created a Straight Table that presents;

Forecast = sum of Act Stock+ all previous Purchase Orders - All Previous Sales Orders

I need to update the Act Stock of each Quarter as the closing forecast

of the previous Quarter. (See screenshot below).

I thought using the function FieldValue('Forecast',n) but I get Null values for any n number.

I will appreciate any approach.

Thanks

Re: Get fieldvalue In Chart

swuehl — Sun, 27 Nov 2011 11:29:29 GMT

Ori Tal,

is you Forecast a field or do you calculate in the chart?

I think you could probably use chart inter record functions for that, something like above(Forecast) as (partial?) expression to update your actual stock. Or put your expression to calculate Forecast in the above function above(sum(ActStock)+...)

Please have a look into the different chart inter record functions, also into rangesum(), they are really helpful for things like this.

If you upload a small sample, I or someone else here in the forum is probably able to help you with the syntax.

Regards,

Stefan

Re: Get fieldvalue In Chart

orital81 — Sun, 27 Nov 2011 13:30:41 GMT

Hi Stefan,

Thanks for the quick reply and the Tip.

I used RangeSum and Above functions as shown below and it workws perfect:

Top(Sum(Forecast_ActStock))+rangesum (above(sum(Forecast_PO),1,4)) -rangesum (above(sum(Forecast_SO),1,4))