37 Replies Latest reply: Feb 3, 2017 2:56 AM by Aniket Surve RSS

    Rangesum() in running total Help.

    Aniket Surve

      Hi Team,

       

      Iam using rangesum and above function and plotting running total against (ID,Year,month).

      Consider we have Year as 2015 and 2016.

      If we select both the years the running total against the month is coming perfect,

      But once i select 2016 the running total get affected as the rows get reduced for 2016.

       

      i'am using the below expression :

       

      =RangeSum(Above(TOTAL Sum({<MONTH=,YEAR=>}Amount),0,12))

       

      Can someone guide me for an expression which should give static result against the respective month even after we select 2016.

       

       

      Thank You.

      Scripting

      QlikView App Development

      New to QlikView