Chart with multiple dimensions

[new2qlik2]

Hi,

My data is set up in the following format

Task A          |    Team A-Yes  | Team B - NULL |  Team C-Yes  |    Team D - NULL |     Team E - NULL

Task B          |    Team A-NULL  | Team B - NULL |  Team C-Yes   |   Team D - NULL |     Team E - NULL

Task C          |    Team A-Yes  | Team B - Yes  |  Team C-Yes  |    Team D - NULL |     Team E - Yes

Task D          |    Team A-NULL  | Team B - NULL |  Team C-NULL|   Team D - Yes|     Team E - Yes

I would like to set up a bar chart such that Team A, B, C, D, E are the X Axis and a count of (task) is the Y axis. I cannot get more than 2 dimensions in a bar chart though?

[anat]

may be this is not the exact solution ,but we can get the desired results.

attached the qvw file.

[hanna_choi]

Hello New2qlik2.

could you are changing your table like below pictures?

The X-axis is Team and Y-axis is count(Task).

Best Regard

hanna.choi

[Ravi_Nagmal]

@new2qlik2 Try unticking show legend option under Appearance

[vinieme12]

use CrossTable Load to unpivot your Dataset

CrossTable(TeamNumber, TeamName, 1)
temp:
load * Inline [
Task | Team1 | Team2 | Team3 | Team4 | Team5
Task A          |    Team A-Yes  | Team B - NULL |  Team C-Yes  |    Team D - NULL |     Team E - NULL

Task B          |    Team A-NULL  | Team B - NULL |  Team C-Yes   |   Team D - NULL |     Team E - NULL

Task C          |    Team A-Yes  | Team B - Yes  |  Team C-Yes  |    Team D - NULL |     Team E - Yes

Task D          |    Team A-NULL  | Team B - NULL |  Team C-NULL|   Team D - Yes|     Team E - Yes
]
(delimiter is '|');

Load *
,subfield(TeamName,'-',1) as new_teamName
,subfield(TeamName,'-',2) as new_teamYesNo
Resident temp;

drop table temp;

Then use   new_TeamName as X-Axis and 

Count(Task) as Y-axis

[Ahidhar]

try this

tab:
CrossTable(Task1,Team1)
load * Inline
[
Task|Team A|Team B|Team C|Team D|Team E
Task A | Team A-Yes | Team B - NULL | Team C-Yes | Team D - NULL | Team E - NULL

Task B | Team A-NULL | Team B - NULL | Team C-Yes | Team D - NULL | Team E - NULL

Task C | Team A-Yes | Team B - Yes | Team C-Yes | Team D - NULL | Team E - Yes

Task D | Team A-NULL | Team B - NULL | Team C-NULL| Team D - Yes| Team E - Yes
]
(delimiter is '|');

tab1:
load Task,Team,"Yes/No" where not isnull("Yes/No");
load Task,Team,if("Yes/No"='NULL',null(),"Yes/No") as "Yes/No";
load
Task,
Task1 as Team,
trim(SubField(Team1,'-',2)) as "Yes/No"
resident tab; drop table tab;

[new2qlik2]

I was doing this with a powerquery in excel prior to loading data to Qlik. I am not trying to do away with the powerquery. Thank you for your suggestion though!