6 Replies Latest reply: Jul 19, 2017 1:38 PM by Robert Hutchings Branched from an earlier discussion. RSS

    Re: Problem with Color by Dimension

    Benjamin VICTOR

      Hello Michael,

       

      I have a similar problem with the 3.2. I have a pie chart with one dimension, one alternative dimension and one measure. The chart is colored by dimension, but it'd seem that I can only use one dimension. It was working fine in 3.1

      QS pb.png

      Cheers

       

      Benjamin

        • Re: Problem with Color by Dimension
          Michael Tarallo

          Hello Benjamin - In order to color by a dimension that is not displayed in the chart, I believe it needs to be part of a hierarchy or date structure where the value is within or part of another value - such as region, state. Such as Many to one.

           

          See attached .qvf

           

          Note that only East shows 1 color because only 1 State exists in the East region - but for the other regions, multiple states exist in the region so therefore it cannot color by any one state - as there are multiple for the region.

           

           

          BUT - If I used State as my dimension - Each state only belongs to one region - so therefore it can color by region.

           

           

          This is showing color by region, but state is my displayed pie slice dimension

           

          If using Qlik Sense Desktop please copy .qvf file to your C:\Users\<user profile>\Documents\Qlik\Sense\Apps and refresh Qlik Sense Desktop with F5. If using Qlik Sense Enterprise Server please import .qvf into your apps using the QMC - Qlik Management Console.

           

          Does this make sense?

           

           

          When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

           

          Regards,

           

          Michael Tarallo (@mtarallo) | Twitter

          Qlik

            • Re: Problem with Color by Dimension
              Benjamin VICTOR

              Thanks for your quick reply. However this doesn't solve my problem. I'll try to be more precise.

               

              I want to be able to display a pie chart depending on 3 different dimensions with no relationships between them (like Product, City and Sales Rep for example). In order to achieve that, in my pie chart proprieties, I have 1 dimension and 2 alternative dimensions.

              Then I want to color my pie chart by dimension, but I can only select 1 dimension in the "colors and legend" tab. So the 2 others dimensions won't be colored at all ! It is a regression as I didn't have the problem with previous versions.

               

              Is there a workaround for this problem. I assume I am not the only one using alternative dimensions and wanting to color them.

              Hope I was clear this time

               

              Thanks in advance

              Benjamin

              • Re: Problem with Color by Dimension
                Nathalie Luna Persson

                Hi Michael.

                 

                I too feel hampered by this feature of the alternative dimensions having to be related (or rather a subset of the first dimension) in order for the colors to come out right.

                 

                To me, the alternative dimensions are a enormous space saver, giving the end-user freedom to choose how to look at his/her data.

                 

                Is there a solution on it's way?

                 

                So far, my solution has been to create a MasterItem dimension, controlled by the value of a variable and then a button for the end-user, changing the value of the variable. Works like a charm, BUT the end-user does not see the selection made in the upper frame of the window and for the seldom/novice end user this is a bit complicated and confusing.

                 

                I would also like to thank you for all your helpful videos and blog posts. They have helped me and my colleagues immensely in our transition to Qlik =)

                 

                Cheers

                 

                Nathalie

                  • Re: Problem with Color by Dimension
                    Robert Hutchings

                    Hi Nathalie

                     

                    I posted this on another thread (On June 2017 thread)

                     

                    Hi Sebastian

                     

                    2- When you set persistent colors, if you set alternative dimensions this only works with one of the alternatives.

                     

                    This has always been a slight issue but it's worse now. Before this release if I selected 'Colors Auto' it defaulted with some charts to the selected alternative dimension. Now it doesn't. In other words coloring by dimension doesn't work with alternatives anymore. So the great new June 2017 feature (using master dimension coloring) is a bit limited if alternative are used

                     

                    The obvious way for QLIK to get around this problem (and it has existed since alternatives was first introduced) is to have two selection options along with all of the dimensions. Either

                     

                    • Selected 1st Data alternative dimension
                    • Selected 2nd Data alternative dimension.

                     

                    This would be fine for every chart except the tree map where three or more dimensions are used. and I don't use alternatives for the tree map. For tree maps Qlik could link colors to the alternative like with tables but as a temporary fix the above should be easy to introduce.

                     

                    TBH I almost always color by the selected dimension anyway so I would always select one or other of these above 2 options

                     

                    As a work around 'By Expression' can be used. But hopefully Qlik will sort this soon

                     

                    if (wildmatch ([Product Type], 'Rhythm*' ) ,'#282828',

                    if (wildmatch ([Product Type], 'Herbal*' ) ,'#f8981d' ,

                    if (wildmatch ([Product Type], 'coco i*' ) ,'#545352' ,

                    if (wildmatch ([Product Type], 'Chocolate*' ) ,'#cb7c18' ,

                    if (wildmatch ([Product Type], 'vitamin*' ) ,'#ffcf02',

                    if (wildmatch ([Product Type], 'coco y*' ) ,'#7b7a78' ,

                    if (wildmatch ([Product Type], 'organic*' ) ,'#e3b902' ,

                    if (wildmatch ([VP Sales], 'April*' ) ,'#282828',

                    if (wildmatch ([VP Sales], 'Dan*' ) ,'#f8981d' ,

                    if (wildmatch ([VP Sales], 'Rand*' ) ,'#545352' ,

                    black()   ))))))))))

                • Re: Problem with Color by Dimension
                  Benjamin VICTOR

                  Thanks for your quick reply. However this doesn't solve my problem. I'll try to be more precise.

                   

                  I want to be able to display a pie chart depending on 3 different dimensions with no relationships between them (like Product, City and Sales Rep for example). In order to achieve that, in my pie chart proprieties, I have 1 dimension and 2 alternative dimensions.

                  Then I want to color my pie chart by dimension, but I can only select 1 dimension in the "colors and legend" tab. So the 2 others dimensions won't be colored at all ! It is a regression as I didn't have the problem with previous versions.

                   

                  Is there a workaround for this problem. I assume I am not the only one using alternative dimensions and wanting to color them.

                  Hope I was clear this time

                   

                  Thanks in advance

                  Benjamin

                  • Re: Problem with Color by Dimension
                    Robert Hutchings

                    Hi

                     

                    This is a design flaw with Sense and it still hasn't been fixed it seems. Its been an issue right from the time alternatives (drill around) have been available. Its so obviously a problem

                     

                    It makes the (brilliant) new master color values feature (June 2017) almost useless if alternatives are used. in fact it is useless. Unless there is a way to overcome this using say an expression.