help with charts

[#1]

I'm having some trouble creating the chart we need.  here is the concept, any suggestions on how to do it is appreciated.  The problem I have is there are over 100 products and I don't want to create an expression for each, but I want to see the skill level of the worker of group.

[Anonymous]

Hi John,

have a look at the below:

https://community.qlik.com/blogs/qlikviewdesignblog/2015/06/12/right-chart-for-the-data-and-for-the-...

[Kushal_Chawda]

can you please share the sample with expected output?

[prieper]

If your datamodel looks, as shown in the first graphic, suggest to normalize the data with CROSSTABLE-functionality, e.g.

CROSSTABLE LOAD (Product, Skill, 2) * FROM ....

This should deliver a table like

Name Group Product Skill

W1 spades 1 1

W1 spades 3 1

W2 hearts 1 3

....

This way should enable you (along with some smaller conditional restrictions) to build your charts.

Peter

[somenathroy]

Hi,

Load script may look like this :

Data:

CrossTable(Product,Skill,2) LOAD *;

LOAD * Inline

[Name,Group,Product1,Product2,Product3,ProductN

Worker1,Spades,1,,4,

Worker2,Hearts,3,,2,2

Worker3,Hearts,2,1,,3

WorkerN,Spades,1,2,,4];

MSkill:

LOAD * Inline

[Skill, Level

1,Novice

2,Intermediate

3,Advanced

4,Experts];

And an UI bar Chart containing Level in Dimension and Count({<Skill={1,2,3,4}>}Name) as an expression could result the required output.

Regards,

Som

[#6]

Thank you. great information!