Expression dependant on fields

Tue, 08 Mar 2011 14:19:52 GMT

I would like to input an expression that tells Qlikview to use the actual expression up to the last complete week and beyond that to use our own the forecast values.

I currently have the following fields/variables:

LCW - Last Complete Week eg Wk44 Field only

CURRETNYEAR - Current Year eg F2011 Field & Variable

We have a forecast uploaded into Qlikview and the coding is as follows:

SUM({$ <Forecast.ForecastType = {"KG"}, Forecast.ForecastVersion = {"Current"}>}Forecast.Value)

The Actual data is as follows:

Sum ( {$<STTR_STATUS = {50, 99} >} SoldKG)

I would like to input an expression that tells Qlikview to use the actual expression up to the LCW (CURRENTYEAR & LCW = F2011WK43) and beyond that to use the forecast values.

Is there any way of doing this?

In a chart would it be possible to make the line change colour after the last complete week.

Thanks

Gareth

topic Expression dependant on fields in QlikView

Expression dependant on fields