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


    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?