https://community.qlik.com/t5/App-Development/Stacked-Bar-chart-in-qlikview/m-p/1988183#M81676 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/162494">@Vishnu_murthy</a>&nbsp;, i guess that data is in excel, so i created this scriptr, using crosstable. Hope it works for you, let me know.</P> <P>&nbsp;</P> <P>Aux:<BR />crosstable(Skill, Experience, 4)<BR />LOAD <BR />F1 as Name, <BR />[&nbsp;(Yrs)] as [Tot Exp], <BR />F3 as [Exp Range], <BR />'Basic / Major' as [Skill Type],<BR />asp.net, <BR />[asp.net&nbsp;core], <BR />MVC, <BR />HTML, <BR />CSS, <BR />Bootstrap, <BR />Javascript, <BR />Jquery, <BR />[SQL &amp; Advanced SQL], <BR />[Stored Procedures/ Triggers/ Functions], <BR />Webapi, <BR />Angular<BR />FROM<BR />[C:\Users\fabia\OneDrive\Documentos\data.xlsx]<BR />(ooxml, embedded labels, header is 1 lines, table is Hoja1);</P> <P>crosstable(Skill, Experience, 4)<BR />LOAD <BR />F1 as Name, <BR />[&nbsp;(Yrs)] as [Tot Exp], <BR />F3 as [Exp Range], <BR />'Other' as [Skill Type],<BR />[React Js], <BR />Oracle, <BR />[iBolt (Magic Xpi)], <BR />[Azure Fundamentals], <BR />[Azure DevOps], <BR />Salesforce, <BR />SEO, <BR />[Machine Learning], <BR />[AWS Hosting], <BR />[Azure Hosting], <BR />[Windows Application], <BR />[Mongo DB], <BR />TFS<BR />FROM<BR />[C:\Users\fabia\OneDrive\Documentos\data.xlsx]<BR />(ooxml, embedded labels, header is 1 lines, table is Hoja1);</P> Mon, 03 Oct 2022 13:24:07 GMT QFabian 2022-10-03T13:24:07Z https://community.qlik.com/t5/App-Development/Stacked-Bar-chart-in-qlikview/m-p/1987874#M81642 <P>Hii,</P> <P>I have data like this</P> <TABLE width="1792"> <TBODY> <TR> <TD rowspan="2" width="64">Name</TD> <TD rowspan="2" width="64">Tot Exp<BR />&nbsp;(Yrs)</TD> <TD rowspan="2" width="64">Exp Range</TD> <TD colspan="12" width="768">Basic/ Major Skills</TD> <TD colspan="13" width="832">Other Skills- eg DevOps CI-CD, Mongo/Cosmo DB etc</TD> </TR> <TR> <TD width="64">asp.net</TD> <TD width="64">asp.net&nbsp;core</TD> <TD width="64">MVC</TD> <TD width="64">HTML</TD> <TD width="64">CSS</TD> <TD width="64">Bootstrap</TD> <TD width="64">Javascript</TD> <TD width="64">Jquery</TD> <TD width="64">SQL &amp; Advanced SQL</TD> <TD width="64">Stored Procedures/ Triggers/ Functions</TD> <TD width="64">Webapi</TD> <TD width="64">Angular</TD> <TD width="64">React Js</TD> <TD width="64">Oracle</TD> <TD width="64">iBolt (Magic Xpi)</TD> <TD width="64">Azure Fundamentals</TD> <TD width="64">Azure DevOps</TD> <TD width="64">Salesforce</TD> <TD width="64">SEO</TD> <TD width="64">Machine Learning</TD> <TD width="64">AWS Hosting</TD> <TD width="64">Azure Hosting</TD> <TD width="64">Windows Application</TD> <TD width="64">Mongo DB</TD> <TD width="64">TFS</TD> </TR> <TR> <TD>a</TD> <TD>5</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0.8</TD> <TD>0.4</TD> <TD>0.6</TD> <TD>0.6</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>b</TD> <TD>4</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0.8</TD> <TD>0.4</TD> <TD>0.6</TD> <TD>0.6</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>c</TD> <TD>6</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0.8</TD> <TD>0.4</TD> <TD>0.6</TD> <TD>0.6</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>d</TD> <TD>7</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0.8</TD> <TD>0.4</TD> <TD>0.6</TD> <TD>0.6</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>e</TD> <TD>0.6</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0.8</TD> <TD>0.4</TD> <TD>0.6</TD> <TD>0.6</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>f</TD> <TD>2</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0.8</TD> <TD>0.4</TD> <TD>0.6</TD> <TD>0.6</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>g</TD> <TD>5</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0.8</TD> <TD>0.4</TD> <TD>0.6</TD> <TD>0.6</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>h</TD> <TD>7</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0.8</TD> <TD>0.4</TD> <TD>0.6</TD> <TD>0.6</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>i</TD> <TD>4</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0.8</TD> <TD>0.4</TD> <TD>0.6</TD> <TD>0.6</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>j</TD> <TD>7</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0.8</TD> <TD>0.4</TD> <TD>0.6</TD> <TD>0.6</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>k</TD> <TD>5</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0.8</TD> <TD>0.4</TD> <TD>0.6</TD> <TD>0.6</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>l</TD> <TD>7</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0.8</TD> <TD>0.4</TD> <TD>0.6</TD> <TD>0.6</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>m</TD> <TD>8</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0.8</TD> <TD>0.4</TD> <TD>0.6</TD> <TD>0.6</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>n</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0.8</TD> <TD>0.4</TD> <TD>0.6</TD> <TD>0.6</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>o</TD> <TD>0.5</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0.8</TD> <TD>0.4</TD> <TD>0.6</TD> <TD>0.6</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> <TD>0</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I need out put</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Vishnu_murthy_0-1664688514020.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/90375i4ABE434E4204AFAF/image-size/medium?v=v2&amp;px=400" role="button" title="Vishnu_murthy_0-1664688514020.png" alt="Vishnu_murthy_0-1664688514020.png" /></span></P> <P>&nbsp;</P> <P>Dimesions like java,.net,sql...etc(skills/unskills)</P> <P>measurement like&nbsp;experience</P> <P>&nbsp;</P> Sun, 02 Oct 2022 05:30:24 GMT https://community.qlik.com/t5/App-Development/Stacked-Bar-chart-in-qlikview/m-p/1987874#M81642 Vishnu_murthy 2022-10-02T05:30:24Z https://community.qlik.com/t5/App-Development/Stacked-Bar-chart-in-qlikview/m-p/1988183#M81676 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/162494">@Vishnu_murthy</a>&nbsp;, i guess that data is in excel, so i created this scriptr, using crosstable. Hope it works for you, let me know.</P> <P>&nbsp;</P> <P>Aux:<BR />crosstable(Skill, Experience, 4)<BR />LOAD <BR />F1 as Name, <BR />[&nbsp;(Yrs)] as [Tot Exp], <BR />F3 as [Exp Range], <BR />'Basic / Major' as [Skill Type],<BR />asp.net, <BR />[asp.net&nbsp;core], <BR />MVC, <BR />HTML, <BR />CSS, <BR />Bootstrap, <BR />Javascript, <BR />Jquery, <BR />[SQL &amp; Advanced SQL], <BR />[Stored Procedures/ Triggers/ Functions], <BR />Webapi, <BR />Angular<BR />FROM<BR />[C:\Users\fabia\OneDrive\Documentos\data.xlsx]<BR />(ooxml, embedded labels, header is 1 lines, table is Hoja1);</P> <P>crosstable(Skill, Experience, 4)<BR />LOAD <BR />F1 as Name, <BR />[&nbsp;(Yrs)] as [Tot Exp], <BR />F3 as [Exp Range], <BR />'Other' as [Skill Type],<BR />[React Js], <BR />Oracle, <BR />[iBolt (Magic Xpi)], <BR />[Azure Fundamentals], <BR />[Azure DevOps], <BR />Salesforce, <BR />SEO, <BR />[Machine Learning], <BR />[AWS Hosting], <BR />[Azure Hosting], <BR />[Windows Application], <BR />[Mongo DB], <BR />TFS<BR />FROM<BR />[C:\Users\fabia\OneDrive\Documentos\data.xlsx]<BR />(ooxml, embedded labels, header is 1 lines, table is Hoja1);</P> Mon, 03 Oct 2022 13:24:07 GMT https://community.qlik.com/t5/App-Development/Stacked-Bar-chart-in-qlikview/m-p/1988183#M81676 QFabian 2022-10-03T13:24:07Z