topic Re: Color by measure in Integration, Extension & APIs

Color by measure

gshockxcc — Sun, 20 Aug 2017 19:59:12 GMT

I am new to Qlik Sense, but I've been doing some low-level development in Qlikview for a couple of years. I have a simple bar chart with 4 measures, each with different set analyses. I would like to create a custom color for each one. The color by expression applies the color to all 4 bars. I can't figure out how to do a color by measure without an enormous "IF" statement (which doesn't work.)

Attached is the bar chart I have, and I'm trying to color each bar independently.

Re: Color by measure

Patrik_Lundblad — Mon, 21 Aug 2017 06:40:40 GMT

Hi Kristan,

If you add the expressions as measures to the library it's then possible to assign a color per measure.

Which are then used to color each measure by the assigned color.

Best regards,

Patrik.

Re: Color by measure

gshockxcc — Sat, 23 Sep 2017 22:33:41 GMT

Patrik,

Thanks for your response, and I'm sorry it took so long to answer you. If there are Alternate Dimensions, is it possible to use multiple colors? Suppose my primary dimension is Month, and secondary dimension is Weeks. Assume I have 4 weeks per month. If I choose a color for the Measure, all 4 weeks will have the same color, within each Month dimension. But each of the Months, will have a different color.

Thank you in advance.

Re: Color by measure

Patrik_Lundblad — Mon, 25 Sep 2017 06:32:34 GMT

Hi Kristan,

Currently not possible, but we have in our plans a solution that I believe would work with your scenario. Although you would probably have to assign one color per week. So not sure how feasible that is.

Best regards,

Patrik.

Re: Color by measure

shraddha_g — Mon, 25 Sep 2017 07:09:14 GMT

in this case you will have to use color by expression and assign colors to each month,

then see if it applies colors to weeks according to month

Re: Color by measure

gshockxcc — Sat, 30 Sep 2017 15:39:12 GMT

Patrick, Shraddha,

Thanks to both of you. I will work with the color options to assign them to individual months.

Re: Color by measure

ecolomer — Sat, 30 Sep 2017 17:45:40 GMT

You can see this:

Re: Color by Variable

Re: Color by measure

vkish16161 — Sun, 01 Oct 2017 04:33:22 GMT

Patrick,

Is there a way to add the color or better yet a master measure directly from the accordion panel on the right? This feature should inherit all the properties (i.e. numeric formatting, color, etc. ) and get stored as a master measure..

Same goes for master dimension and master visualizations.

Re: Color by measure

Patrik_Lundblad — Mon, 02 Oct 2017 08:33:16 GMT

Hi Vishnu,

Currently not possible. But on our list of things to look into.

Best regards,

Patrik.