0 Replies Latest reply: Mar 8, 2011 9:19 AM by Gareth Joubert RSS

    Expression dependant on fields

    Gareth Joubert

      Hi

      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