Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

igdrazil
Contributor III

Colouring by Dimension

Hi Community,

We're using the September 2017 Version of Qlik Sense Desktop and Enterprise. The Functionality of the Master Dimensions increased by a lot, BUT I think they aren't working properly at the moment.

When I create a Master Dimension, calculated via some if-clauses, I can use it just fine and it does deliver me the correct values, but the coloring does not work at all. When using the Master Dimension, every Dimension Value will be colored as the "Null"-Color.

My Dimension does look like the following:

if(dim = a OR dim = b, 'hub',

if(dim = c OR dim = d ... OR dim = m, 'CC', 'NA'))

The inner if-clause has 13 values.


For my Measure, I'm using a simple "count(distinct user_id)".

I can't provide a sample of data because it's company internal data that I am not allowed to share.

I hope anyone can help me on this.

Kind Regards

Chris

16 Replies
mdmukramali
Valued Contributor II

Re: Colouring by Dimension

Hi Christoph,

I have created a Dimension (CategorySubCategory) with If Clauses:

like below :

=if(CategoryName='Baby Clothes' or CategoryName='Childrens Clothes','Baby',

if(CategoryName='Mens Clothes' or CategoryName='Mens Footwear','Men',

        if(CategoryName='Sportswear' or CategoryName='Swimwear','sports',

            if(CategoryName='Womens Clothes' or CategoryName='Womens Footwear','Women'))))

277599.PNG

selected the color of each CategorySubCategory value:

277599_1.PNG

277599_1.PNG

277599_2.PNG

Which is working fine.

Highlighted
igdrazil
Contributor III

Re: Colouring by Dimension

Hi Mohammed,

thank you for your fast reply. Let me show you how it does look for me.2017-10-11 12_01_08-Campus 2.0 - Campus Team 0.2 _ Sheets - Qlik Sense.png

2017-10-11 12_02_00-Campus 2.0 - Campus Team 0.2 _ Sheets - Qlik Sense.png

2017-10-11 12_02_48-Campus 2.0 - Campus Team 0.2 _ Sheets - Qlik Sense.png

2017-10-11 12_03_18-Campus 2.0 - Campus Team 0.2 _ Sheets - Qlik Sense.png

When I set it to auto Colors, it is still the same (grey with more grey). BUT when I set the Null Color to green for example, the whole graphic will also be green. So my guess would be that the calculation for the coloring does not work, since I only get Null-Values for coloring.

Kind Regards

Chris

EDIT: Yes I did try to turn on the "Library colors" option

shraddha_g
Honored Contributor III

Re: Colouring by Dimension

Turn on "Library Colors" Option.

igdrazil
Contributor III

Re: Colouring by Dimension

Did try that already!

Even if that was the problem, the chart should be shown in the standard 12 color array then, when this option is disabled.

mdmukramali
Valued Contributor II

Re: Colouring by Dimension

Dear Christoph,

Can you enable library colors :

277599_3.PNG

And one more thing can you try to drop [user.resposible_hub_cc] and HUB/CC the fields in the front end,

and check when you select  data from [HUB/CC]  related data selected from  [user.resposible_hub_cc] field.


Thanks,

Mukram.

igdrazil
Contributor III

Re: Colouring by Dimension

Dropping the dimension, setting to auto colors, unlinking, manually copying in the formula into the dimension field. In the end, I get a greyed out Pie-Chart. I tried all of this already. And it's not only this chart with this dimension. For me, not a single Master Dimension works.

I don't think this is a problem of options that are done or not, but a Bug in Qlik Sense September.

mdmukramali
Valued Contributor II

Re: Colouring by Dimension

Dear,

can you try attached application check the functionality?

shraddha_g
Honored Contributor III

Re: Colouring by Dimension

I had same issue..

If you have calculated dimension then I was not getting standard color.

One option is creating that calculated dimension Load Script and use that field in Dimension

igdrazil
Contributor III

Re: Colouring by Dimension

Your example does work for me on my desktop version.