1 Reply Latest reply: Mar 4, 2017 12:09 AM by Shraddha Gajare RSS

    formulars

    Patrick Eberlein

      Hello everybody

       

      I use Qlik Sense iVm. Corporate Planning.

       

      Have various problems,

      1. I want to create a table with accumulated sales values. However, as I want to summarize several months, I can not put any fixed months into my formula.

       

      2. I want to put the actual values of two dimensions (I have given in CP) into a formula. (E.g. Sum (Turnover_PC) Actual / sum (Turnover_PC)

      However, I do not come to a suitable formula ...

       

      3. I would like to calculate the share of an account group in the total turnover. Again, I do not find a suitable formula after many attempts

       

      Can someone please help me with formulas?