4 Replies Latest reply: Jan 5, 2016 11:19 AM by Kamil Lewandowski RSS

    Aggregation stacked chart with two dimensions

    Kamil Lewandowski

      Hi. I need to create calculated measure so that it is shown on stacked bar chart with two dimension (Year and Customer), but aggregated...

      So far I have this measure:

      sum({$<Customer=,Year=>}Aggr(Sum(Amount),Customer,Year))

      what gives me that:

       

      Numbers are ok, customers are ok on legend, but it not aggregated by years at all.

      Hope you get my problem and I hope that there is someone who has idea for this problem.

        • Re: Aggregation stacked chart with two dimensions
          Andy Weir

          perhaps if you create what your looking for in excel and post on here we can guide you better to an outcome.

          • Re: Aggregation stacked chart with two dimensions
            Michael Tarallo

            Hi Kamil,

             

            In addition to Andy's request for more information, I would suggest you create a table object with the data in it as well, so you can see the numbers that are being used in the chart. That way you will have a better understanding of the calculation and to see if it is accurate.

             

            I am not sure what you mean by "but it not aggregated by years at all."

             

            The chart is showing years across the bottom - so the amount is being aggregated by customer, for each year.

             

            I am not sure if the aggr() function is giving you what you expect. Let me conduct some research and get back to you.

             

            Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

             

            Regards,

            Mike Tarallo

            Qlik

            • Re: Aggregation stacked chart with two dimensions
              Michael Tarallo

              In the mean-time as a I research, see if this community post helps:

               

              Aggr() - this post explains a bit and provides some links out to other resources.

               

               

              Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

               

              Regards,

              Mike Tarallo

              Qlik

                • Re: Aggregation stacked chart with two dimensions
                  Kamil Lewandowski

                  Thank for your interest.

                  By aggregating by years i mean values should be summing up:

                  2013:                               5,03M

                  2014=2014+2013:           6,81M

                  2015=2015+2014+2013: 7,9M

                   

                  I guess I need to use functions rangesum and above, but i dont know how. Data below

                   

                   

                  YearCustomerAmount
                  20141000010132
                  2014200008773,8
                  2014300001891
                  20145000076907,4
                  20144000049321
                  20146000011334
                  2014610001637
                  2014620005155
                  201510000267842,85
                  201520000268709,05
                  201530000174009,95
                  201550000100122,6
                  20154214725870392,15
                  2015436871293744,34
                  2015326565654297,24
                  201549633663421,71
                  2015468978899433,38
                  201514455442781,92
                  201547563218139509,13
                  201535963852241342,9
                  201535451236109665,42
                  201540000112469
                  2015452828291251,95
                  201542369147116,6
                  201560000139990
                  201561000240280
                  201562000131562
                  201610000132193
                  201620000231286,6
                  20163000036759,55
                  201650000187546,7
                  20164000096617
                  20166000059460
                  20166100099019
                  201662000101950