Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
benvictor
Partner - Contributor
Partner - Contributor

Re: Problem with Color by Dimension

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

6 Replies
Michael_Tarallo
Employee
Employee

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

Regards,
Mike Tarallo
Qlik
benvictor
Partner - Contributor
Partner - Contributor
Author

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

benvictor
Partner - Contributor
Partner - Contributor
Author

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

robert99
Specialist III
Specialist III

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.

Not applicable

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

robert99
Specialist III
Specialist III

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()   ))))))))))