10 Replies Latest reply: Mar 4, 2014 4:59 PM by Christian Lauritzen RSS

    Labels on Mekko-chart made of a Scatter chart?

    Christian Lauritzen

      The initial challenge was to get a numeric x-axis? That was solved by building the Mekko using a scatter chart. Now, the problem is to get labels on the boxes. Can that be solved?

       

      Christian

        • Re: Mekko Chart with numeric x-axis?
          Byron Van Wyk

          Regarding the chart with reference to the waterfall thread. What if I am presented with a situation where volume sold is the same as another country. Would they overlap or would it be presented in a 3d dimensional way? I just find this visual very hard to interpret and takes some cognitively thinking to understand what it is that I am seeing.

           

          Otherwise, I did try and give a bash, but was unable to get the same visual output

           

          Cheers,

          Byron Van Wyk

          qlikviewramblings.blogspot

          • Re: Mekko Chart with numeric x-axis?
            Byron Van Wyk

            Not bad at all It's actually looking very close to what you wanted.  Upload this so long if you want to. Would love to have a look at it and see what you did

             

             

            Cheers,

            Byron

              • Re: Re: Mekko Chart with numeric x-axis?
                Christian Lauritzen

                My pleasure! It is attached. I guess you will be a bit surprised when you discover what type of chart it is . I got stuck with the traditional Mekko-chart, so I needed to think a little bit outside the box.

                 

                Still, a new label challenge remains. So far, I haven't got a clue on how to solve it, and I do not wish to overlay a transparent chart only for the labels. That's cheating.

                 

                Any creative ideas?

                 

                /Christian

                  • Re: Mekko Chart with numeric x-axis?
                    Byron Van Wyk

                    If I could I would like this 10 times as much. Serious Christian, I am very impressed by your ingenuity! I am still wrapping my head around how you figured this out and knew that, that particular style of a scatter chart would give you this visual output. Absolutely brilliant!

                     

                    I look forward to seeing your update on this

                     

                     

                    Cheers,

                    Byron

                      • Re: Mekko Chart with numeric x-axis?
                        Christian Lauritzen

                        Thanks Byron. The secret sauce is that a scatter charts could be used to draw lines, This opens up an ocean of possibilities. I was initially inspired by a really great blog post by matt.crowther (New Qlikview Indexed Explosion Quadrant Chart | QVDesign) where he introduced Value List and Value Loop (I recommend his blog if you have not read it). It made me realize that you can more or less can create any type of graph using Scatter charts. I started off experimenting with  Re: Is there an artist in you? just to play around. I followed up by this; New variant of Scatter: Overlapping Box Areas, as an attempt to make something useful of this insight (not succeeding since the application of the Box Area graph is very limited). From there, the step of transforming the Area graph into a Mekko chart should have been short, but it took me a while before a realized the obvious. I think these examples will prove interesting for anyone wanting to explore more about Qlikview.  Still, as mentioned, the label issue remains for someone to solve.

                         

                        So, how does it work? The chart draws squares, using fields X and Y for coordinates (0,0 -> 0,1 -> 1,1 -> 1,0 -> 0,0), where field X is used in the first dimension and then both fields X and Y are used as first and second expressions. Basically, the coordinates are looped through. To create the Mekko, a second dimension, here the Item field, is added to get different boxes. Field X (X-coordinates) is scaled with field A and is then offset with the above sum of the first expression (the previous rows blocks - much like a waterfall). The same is done for field Y (Y-Coordinates) that is multiplied by field B, but it is not offset. In a real application, A could be price per unit and B could be # of units. So, why the 1.00000001 etc? Because otherwise Qlikview would have summarized the Y-coordinates on X=0 and X=1. Due to the tiny decimals, the X-coordinates are different, hence not summarized, even though the difference is so small that the Y-values still graphically appear to be on the same X-location. Hope that clarifies! Quite simple once you get your head around it.

                         

                        Now, let's hope that someone clever can figure out the label challenge. I don't have a clue how to solve it. I have only succeed in displaying x-values, and that is not so useful.  I wold like left aligned labels above the top left corner (the 4th coordinate ) of each box.

                         

                        Christian

                  • Re: Mekko Chart with numeric x-axis?
                    Christian Lauritzen

                    Ideas anyone? Would be grateful for help on this one!