topic Re: Tree map color assignment and ordering in QlikView

Tree map color assignment and ordering

Fri, 10 Jul 2015 17:50:52 GMT

Hello everyone,

I am very new to qlik sense and all the coding stuffs are new to me. Hope someone can help me navigate around this!

I created a tree map for projects with two dimensions- month and stage, and measure - the amount of money. I want to group them by month and color by stage. I managed to do that but I want to 1) assign a specific color instead of using the pre-assigned color by qlik sense, 2) order the groups (months) chronologically; it's in random order now.

Could someone please help with this? I've been trying to read discussions but not sure where to put these expressions or codes and what not....?

Thank you

Re: Tree map color assignment and ordering

sinanozdemir — Fri, 10 Jul 2015 19:15:00 GMT

Hi Seona,

On the right pane, in the appearance tab, there is an option for colors. You can change colors by dimensions or measure.

Just to make sure that "Colors" switch is off so that you can assign custom colors.

And in terms of ordering, you can use the Data tab to sort the order of the treemap:

Hope this helps.

Re: Tree map color assignment and ordering

Fri, 10 Jul 2015 19:23:56 GMT

Hi Sinan -- thanks for the quick reply!

I have already used the appearance tab by switching off the custom color but I want to use specific colors. Using the example of yours above, for example, I want to change the 2015-01 color (currently skyblue) to red. How can I assign specific colors to specific item?

Also, in terms of ordering the months, I have already used the data tap and put the 'Month' tap on top of other dimensions but I want to have them ordered chronologically from January to December (from left to right). Would I have to make separate columns or .. sort by expression (which is the part that i'm the most confused about).

Thank you for your help!

Re: Tree map color assignment and ordering

sinanozdemir — Fri, 10 Jul 2015 19:57:49 GMT

Hi Seona,

I have tried to apply a function to change the colors of treemap and it didn't work so I am not quite sure if this is possible in QlikSense. Hopefully, someone from Qlik could answer this question.

The sorting part is related to the measure. I think that treemap is measure driven so I tried to sort it by date and it didn't sort chronologically:

I personally believe this is as a result of 2015-05 and 2015-06 having less values than other months.

Hopefully, someone else has another opinion on this one.

Re: Tree map color assignment and ordering

sinanozdemir — Fri, 10 Jul 2015 20:08:14 GMT

Hi Seona,

I just figured it out the color part of it.

In the colors tab, choose "By expression" and type your if statement, please see below:

Here is the expression that I used to change the colors of dimensions:

Thanks

Re: Tree map color assignment and ordering

Fri, 10 Jul 2015 20:39:18 GMT

Hi Sinan!

The expression didn't work for me. Should I write something in the data load editor beforehand?

Re: Tree map color assignment and ordering

sinanozdemir — Fri, 10 Jul 2015 20:41:48 GMT

Would you mind sending me your expression?

Thanks

Re: Tree map color assignment and ordering

Fri, 10 Jul 2015 20:42:46 GMT

Here is my expression.

if(DESC:Stage = '5_Final Proposal Submitted',RGB(255,255,255),RGB(0,0,0))

Re: Tree map color assignment and ordering

sinanozdemir — Fri, 10 Jul 2015 20:45:05 GMT

Can you change it to this

If(Stage = '5_Final Proposal Submitted', RGB(255,255,255),RGB(0,0,0))

I am not sure what "DESC:Stage" is? Is it the full dimension name?

Re: Tree map color assignment and ordering

Fri, 10 Jul 2015 20:48:42 GMT

Yes, that's the full dimension name actually. haha

Re: Tree map color assignment and ordering

sinanozdemir — Fri, 10 Jul 2015 20:51:11 GMT

Then I think you want to do it like this:

If([DESC:Stage] = '5_Final Proposal Submitted', RGB(255,255,255),RGB(0,0,0))

If this doesn't work, can you post a small sample dataset?

Thanks

Re: Tree map color assignment and ordering

Fri, 10 Jul 2015 20:54:49 GMT

Yes that worked! Why would you put a square bracket here and what is the second RGB for?

Thanks so much Sinan

Re: Tree map color assignment and ordering

sinanozdemir — Fri, 10 Jul 2015 20:59:07 GMT

Because when dimension and measure names are funky like this one, (it has special characters or spaces), then you need to enclose them with square brackets.

The second RGB is for if the first condition is not met so if the dimension is not '5_Final Proposal Submitted', then it gives another color. In your case, when dimensions don't have '5_Final Proposal Submitted', then they will be black - RGB(0,0,0) is for color black.

Makes sense?

Re: Tree map color assignment and ordering

Fri, 10 Jul 2015 20:59:44 GMT

If I were to put it multiple if functions, are there any additional things to add? For these below:

if([DESC:Stage]='4_Negotiation/Review',RGB(220,20,60),RGB(0,0,0))

if([DESC:Stage]='3_Proposal/Price Quote',RGB(205,205,0),RGB(0,0,0))

if([DESC:Stage]='2_Formal Presentation',RGB(192,255,62),RGB(0,0,0))

if([DESC:Stage]='1_Identified Opportunity',RGB(135,206,250),RGB(0,0,0))

Re: Tree map color assignment and ordering

sinanozdemir — Fri, 10 Jul 2015 21:02:55 GMT

Then you will need to nest them like the below:

if([DESC:Stage]='4_Negotiation/Review',RGB(220,20,60),

if([DESC:Stage]='3_Proposal/Price Quote',RGB(205,205,0),

if([DESC:Stage]='2_Formal Presentation',RGB(192,255,62),

if([DESC:Stage]='1_Identified Opportunity',RGB(135,206,250),RGB(0,0,0)))))

You can send me a sample dataset and I can try to come up with a solution for the sorting part as well if you would like.

Re: Tree map color assignment and ordering

Fri, 10 Jul 2015 21:15:27 GMT

Got it! Thanks so much

Re: Tree map color assignment and ordering

sinanozdemir — Sat, 11 Jul 2015 03:39:32 GMT

Hi Seona,

I found the below thread about treemap sorting. As I said before, treemap is measure driven and sorting is dependent of the measure.

Treemaps In Qlik Sense

If you think that I was able to answer your questions, please mark this discussion as complete by clicking one of the answers as "Correct Answer".

Thank you.