Chart item to show failures - Qlik Community

Report Inappropriate Content · ‎2013-10-10

Hi,

I have requirement to show %of Failure by Team member Vs Region.

Could anyone let me know which Chart item suits to generate this.

Thanks.

ngulliver · ‎2013-10-10

Hi, Amelia.

I would probably use a pivot table to show the values. You could insert a cycle group as a second dimension to switch between different views of the data whether it be region, country, town etc.

Regards,

Neil

Report Inappropriate Content · ‎2013-10-10

Thanks could you let me know apart from pivot and straight is there any chart item will suit to generate this.

ngulliver · ‎2013-10-10

Well, at a push you could go for a stacked bar chart but this would only really be effective if there were small numbers of regions and team members.

Report Inappropriate Content · ‎2013-10-10

There are big number of regions and team members, so in this case would it be possible to show the total bars instead of individual?

ngulliver · ‎2013-10-10

Hi, Amelia.

No, I don't think so. Have a go but I suspect with so many members and regions you may end up with a large chart full of coloured bricks which may be very difficult to convey useful information and painful on the eyes

Report Inappropriate Content · ‎2013-10-10

Yes you are right. In taht case would Mekko chart suits this?

ngulliver · ‎2013-10-10

Same problem, I'm afraid.

Is it important that the user has a visual representation of the data rather than a table of figures ?

Report Inappropriate Content · ‎2013-10-10

Yes but somehow i tried combo chart will be visible to see as my user will select the data based on week

ngulliver · ‎2013-10-14

Hi, Amelia.

Well I'm all out of ideas. Unless anyone else has any ideas, I recommend you close this ticket.

Regards,

Neil