topic Re: 3 Dimension Coloring in QlikView

3 Dimension Coloring

ksomosera10 — Mon, 11 Sep 2017 02:23:51 GMT

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!

Re: 3 Dimension Coloring

Anil_Babu_Samineni — Mon, 11 Sep 2017 03:23:32 GMT

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

Re: 3 Dimension Coloring

ksomosera10 — Mon, 11 Sep 2017 05:10:33 GMT

Hi Anil,

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

Re: 3 Dimension Coloring

ksomosera10 — Mon, 11 Sep 2017 05:14:07 GMT

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.

Re: 3 Dimension Coloring

Anil_Babu_Samineni — Mon, 11 Sep 2017 05:17:44 GMT

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

Re: 3 Dimension Coloring

ksomosera10 — Tue, 12 Sep 2017 03:19:39 GMT

I'm working on a prototype.

Re: 3 Dimension Coloring

Anil_Babu_Samineni — Tue, 12 Sep 2017 03:36:34 GMT

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

Re: 3 Dimension Coloring

ksomosera10 — Tue, 12 Sep 2017 03:47:31 GMT

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.

Re: 3 Dimension Coloring

shraddha_g — Tue, 12 Sep 2017 04:50:23 GMT

may be,

in Color by Expression,

You can use something like,

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