Stacked Bar chart in qlikview

[Vishnu_murthy]

Hii,

I have data like this

Name	Tot Exp  (Yrs)	Exp Range	Basic/ Major Skills												Other Skills- eg DevOps CI-CD, Mongo/Cosmo DB etc
			asp.net	asp.net core	MVC	HTML	CSS	Bootstrap	Javascript	Jquery	SQL & Advanced SQL	Stored Procedures/ Triggers/ Functions	Webapi	Angular	React Js	Oracle	iBolt (Magic Xpi)	Azure Fundamentals	Azure DevOps	Salesforce	SEO	Machine Learning	AWS Hosting	Azure Hosting	Windows Application	Mongo DB	TFS
a	5		1	0	1	0	0.8	0.4	0.6	0.6	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
b	4		1	0	1	0	0.8	0.4	0.6	0.6	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
c	6		1	0	1	0	0.8	0.4	0.6	0.6	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
d	7		1	0	1	0	0.8	0.4	0.6	0.6	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
e	0.6		1	0	1	0	0.8	0.4	0.6	0.6	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
f	2		1	0	1	0	0.8	0.4	0.6	0.6	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
g	5		1	0	1	0	0.8	0.4	0.6	0.6	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
h	7		1	0	1	0	0.8	0.4	0.6	0.6	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
i	4		1	0	1	0	0.8	0.4	0.6	0.6	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
j	7		1	0	1	0	0.8	0.4	0.6	0.6	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
k	5		1	0	1	0	0.8	0.4	0.6	0.6	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
l	7		1	0	1	0	0.8	0.4	0.6	0.6	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
m	8		1	0	1	0	0.8	0.4	0.6	0.6	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
n	1		1	0	1	0	0.8	0.4	0.6	0.6	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
o	0.5		1	0	1	0	0.8	0.4	0.6	0.6	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0

I need out put

Dimesions like java,.net,sql...etc(skills/unskills)

measurement like experience

[QFabian]

Hi @Vishnu_murthy , i guess that data is in excel, so i created this scriptr, using crosstable. Hope it works for you, let me know.

Aux:
crosstable(Skill, Experience, 4)
LOAD
F1 as Name,
[ (Yrs)] as [Tot Exp],
F3 as [Exp Range],
'Basic / Major' as [Skill Type],
asp.net,
[asp.net core],
MVC,
HTML,
CSS,
Bootstrap,
Javascript,
Jquery,
[SQL & Advanced SQL],
[Stored Procedures/ Triggers/ Functions],
Webapi,
Angular
FROM
[C:\Users\fabia\OneDrive\Documentos\data.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Hoja1);

crosstable(Skill, Experience, 4)
LOAD
F1 as Name,
[ (Yrs)] as [Tot Exp],
F3 as [Exp Range],
'Other' as [Skill Type],
[React Js],
Oracle,
[iBolt (Magic Xpi)],
[Azure Fundamentals],
[Azure DevOps],
Salesforce,
SEO,
[Machine Learning],
[AWS Hosting],
[Azure Hosting],
[Windows Application],
[Mongo DB],
TFS
FROM
[C:\Users\fabia\OneDrive\Documentos\data.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Hoja1);