topic Re: help with charts in QlikView

help with charts

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: help with charts

Anonymous — Fri, 12 May 2017 09:39:04 GMT

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-device

Re: help with charts

Kushal_Chawda — Fri, 12 May 2017 09:48:46 GMT

can you please share the sample with expected output?

Re: help with charts

prieper — Fri, 12 May 2017 09:48:50 GMT

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

Re: help with charts

somenathroy — Fri, 12 May 2017 10:51:48 GMT

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

Re: help with charts

Fri, 12 May 2017 11:26:57 GMT

Thank you. great information!