7 Replies Latest reply: Aug 13, 2015 12:25 PM by jagan mohan rao appala RSS

    Sub-total

      I am havinf the following formula.

      If(Sum({<Year={'$(=Max(Year))'}>} [Amount (LCY)]) > 0 AND Sum({<Year={'$(=Max(Year)-1)'}>} [Amount (LCY)]) = 0 AND Sum({<Year={'$(=Max(Year)-2)'}>} [Amount (LCY)]) = 0, (Sum([Amount (LCY)])))

       

      I am not getting sub-total and count of the above in Qlik sense KPI..

       

      Can anyone modify and provide revised formula such that it displays count and sum total