Alternative Dimension and Colour by Dimension with legend

[ekademeteme]

I am having a challenge in QlikSense.

Suppose:

1. You have a Line chart that has 2 dimensions and 2 or more Alternative Dimensions and One Measure.

2. Then you put colour by dimension and you specify one dimension that is in your Chart

3. You activate show legend.

So my question is.

The Legend only shows values for the dimension you specified in the Colour by Dimension, however when you change the dimension to an Alternative dimension you specified the Legend is always showing values for the First dimension that was specified in the settings during design.

Is there any way of making the Legend match or show the values of the dimension that has been selected.

[vkish16161]

‌This is a known bug in Qlik Sense. Don't mind raising this issue with Qlik. They'll just ignore it.

This issue persists as of September 2017 release. The alternative dimensions/ measures feature is a great but poorly designed feature.

Would help if the there is an expression that drives the legend. Same goes with coloring.

There should be an option to color by an "Alternative Dimension".

mto‌

‌

[Michael_Tarallo]

Hello Edzai -

I checked with our products team and this issue has been identified and is currently tasked to be fixed, it may make it as soon as the November release I am told. Hope this helps.

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

[dionverbeke]

Thanks Michael,

This is good news!

How can we make sure we are not on the ignore list for bug fixes?

I am prepared to write down a list of bugs we see coming back in all releases and really need to be fixed:

* Alternate dimension and colors

* Max 2 dims or 2 meas in barcharts

* Master items in document, not globally on server

* The fixed in Dimension is applied on the measure not the value of the dimensions.

....

Kind Regards,

Dion

[Michael_Tarallo]

Hi Dion - kindly, I would say ignore is a harsh word. I see what goes on in R&D and I can tell you NOTHING is being ignored. - these guys due to bust their tails to meet deadlines and get product out as quickly as possible with pretty decent quality. NOW prioritized, that's more of what is going on. They have their agendas and processes to follow - though I am not sure why some are given more priority than others. That being said - I would always be sure to contact your Qlik rep and/or Qlik support to ensure that the issue has been logged and always request a status update from time to time. On another note, just for those who might think this, Qlik Community is not the best venue to log an issue - it is possible it may be picked up and then logged in our system by someone (for example I used to be able to do that - when I could repro something easily - but no longer have access to do so) - so make sure to use Qlik Support as well and/or the partner portal. Let me know if you have any questions.

[vkish16161]

mto This is good news. Also, a small suggestion in Alt dim / Alt meas.

Sometimes there's a need to look at a particular measure vs. a particular dimension.

(Like, if we're using an Aggr function in the measure that requires the dimension to match the chart dimension)

So, is it possible to also add an option to do a 'linked measure' ?  (As in, a particular dimension could only be viewed with a particular dimension.)

This will relieve some burden for us developers, as currently QS does not natively support Conditional Show / Hide.

You might say why not train users to select the right dimension?   But, most of the users I deal with are used to excel and other BI tools that provide a similar functionality. So, there is a minor protest from their side.

If possible, please include this functionality.

[Anonymous]

Please, please can colour by alternative dimension functionality be added soon?

This is so frustrating when creating simple scatter plots, where for example I must choose ID (individual employees) as my dimension so that I get points on the chart for each employee, but I want to have a legend to colour by some trait about those employees (gender, length of service, performance ratings...)

Yes, colour by expression is a workaround but then I need to create a picture object and paste it on my sheet so that I at least have a legend visible.  This is really inadequate!

Ideally you would want to enable users to choose from a large range of alternative dimensions to help them investigate and explore their data (the whole point of using QS), but for now just having ONE alternative dimension would help so, so much

[prat1507]

HI Michael
Any updates on this?

Regards
Pratyush

[1600eads]

I'm in the same boat here. If I flip through my alternative dimension, it will drop the colors. I tried implementing a color by expression but then it drops the legend. Would like any updates if this is feasible.

Much thanks.