2 Replies Latest reply: Feb 23, 2014 5:07 PM by Jyotsna kora RSS

    Show Budget for whole year and Sales till current month in Qlikview chart

    Jyotsna kora

      Hi,

       

      I need to create a chart in Qlikview, Budget & sales for current year.

       

      I have created the expressions as below

      Budget - sum(Budget) -> Full accumulation

      Sales - sum({$<YYYYMM = {"<=$(=(vCurrentYear)*100 + (vCurrentMonth))"}>} [Sales]) -> Full accumulation

       

       

      It is showing both the expressions from Jan till Dec of 2014, whereas I want budget to be shown from Jan till Dec as we have budget for whole year and sales only till Feb(Current Month). The values are coming correctly but there's this extra line from March to December for sales which should not be shown as they are future dates for sales.

       

      Please advice.

       

      Thanks,

      Jyotsna