Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Did you mean:
Creator II

## 3 Dimension Coloring

Hi,

I've been working with Qlikview and I'm struggling on my current scenario.

I have this graph counting the number of employees for a certain team. I also have 3 dimensions, consists of the skill, the team and a calculated field which returns an employee count if it's knowledge is program or function.

I want to have the color in team rather than in employees. Can you help me out here?

THANKS A LOT!

8 Replies

Can you explain little more, Question was satisfied but we are not sure how we can answer and where you need this?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator II
Author

Hi Anil,

All I want is to make the color on the dimension  be on the Team rather than per Employee.

Creator II
Author

Just to make it simple.

Instead of the first picture. I want it to be like this:

First team is Red, then second team is yellow, 3rd is blue... etc.

rather than having a different colors per team.

I hope this will help you out.

This may useful some what? But please share sample application to test

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator II
Author

I'm working on a prototype.

Like this? By, This is not make sense to me how USER can analyze over measures

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator II
Author

Like what I've shown on my screenshot. I have 3 dimensions with 1 calculated fields and an expression of counting the distinct name of employees for each team. Now, I need the one that you've sent because the color was always pointing on the employees.

For example, If 100 employees are on Team A then, Team A bar graph will have 100 different colors... If 500 employees are on Team B then likewise, Team B bar graph will have 500 different colors grouped, which is not what I want.

I hope I make my self clear on my issues here.

Partner - Master III

may be,

in Color by Expression,

You can use something like,

pick(rank(TeamFieldname),red(),yellow(),blue(),green(),lightgray(),magenta())

Community Browser