topic Excel File/Cross table help in QlikView https://community.qlik.com/t5/QlikView/Excel-File-Cross-table-help/m-p/133672#M756074 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hi - I have attached excel file and QVW ...I have one chart in the qvw but I want another </SPAN><SPAN style="color: #000000; font-size: 10pt; font-family: Calibri;">Bar Chart <STRONG>Actual Savings by Year</STRONG> with </SPAN></P><P><SPAN style="color: #000000; font-size: 16.0pt; font-family: Calibri;"><SPAN style="font-size: 10pt;">toggle by Year, show 2 bars per year (</SPAN><SPAN style="font-size: 13.3333px;">MTMActual</SPAN><SPAN style="font-size: 10pt;">Savings and PSO</SPAN><SPAN style="font-size: 13.3333px;">Actual</SPAN><SPAN style="font-size: 10pt;">Savings)</SPAN></SPAN></P><P><SPAN style="color: #000000; font-size: 10pt; font-family: Calibri;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-size: 10pt; font-family: Calibri;">Is it possible.Any help is appreciated.Thanks much.</SPAN></P><P><SPAN style="color: #000000; font-size: 10pt; font-family: Calibri;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-size: 10pt; font-family: Calibri;"><BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT apthansh 2020-11-25T16:16:04Z Excel File/Cross table help https://community.qlik.com/t5/QlikView/Excel-File-Cross-table-help/m-p/133672#M756074 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hi - I have attached excel file and QVW ...I have one chart in the qvw but I want another </SPAN><SPAN style="color: #000000; font-size: 10pt; font-family: Calibri;">Bar Chart <STRONG>Actual Savings by Year</STRONG> with </SPAN></P><P><SPAN style="color: #000000; font-size: 16.0pt; font-family: Calibri;"><SPAN style="font-size: 10pt;">toggle by Year, show 2 bars per year (</SPAN><SPAN style="font-size: 13.3333px;">MTMActual</SPAN><SPAN style="font-size: 10pt;">Savings and PSO</SPAN><SPAN style="font-size: 13.3333px;">Actual</SPAN><SPAN style="font-size: 10pt;">Savings)</SPAN></SPAN></P><P><SPAN style="color: #000000; font-size: 10pt; font-family: Calibri;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-size: 10pt; font-family: Calibri;">Is it possible.Any help is appreciated.Thanks much.</SPAN></P><P><SPAN style="color: #000000; font-size: 10pt; font-family: Calibri;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-size: 10pt; font-family: Calibri;"><BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Excel-File-Cross-table-help/m-p/133672#M756074 apthansh 2020-11-25T16:16:04Z Re: Excel File/Cross table help https://community.qlik.com/t5/QlikView/Excel-File-Cross-table-help/m-p/133673#M756075 <HTML><HEAD></HEAD><BODY><P>if i understand your issue correctly create a bar chart with 2 dimensions year, initiative</P><P>and if you want only those 2 initiatives use set analysis</P><P> sum( {&lt;Initiative={'MTMActualSavings' ,'PSOActualSavings'}&gt;} [Actual Savings])</P></BODY></HTML> Mon, 17 Sep 2018 16:28:03 GMT https://community.qlik.com/t5/QlikView/Excel-File-Cross-table-help/m-p/133673#M756075 dplr-rn 2018-09-17T16:28:03Z Re: Excel File/Cross table help https://community.qlik.com/t5/QlikView/Excel-File-Cross-table-help/m-p/133674#M756076 <HTML><HEAD></HEAD><BODY><P>Thank you but That will not work as I have different year columns.</P></BODY></HTML> Mon, 17 Sep 2018 17:12:37 GMT https://community.qlik.com/t5/QlikView/Excel-File-Cross-table-help/m-p/133674#M756076 apthansh 2018-09-17T17:12:37Z Re: Excel File/Cross table help https://community.qlik.com/t5/QlikView/Excel-File-Cross-table-help/m-p/133675#M756077 <HTML><HEAD></HEAD><BODY><P>Can you explain in more detail?</P></BODY></HTML> Mon, 17 Sep 2018 18:17:36 GMT https://community.qlik.com/t5/QlikView/Excel-File-Cross-table-help/m-p/133675#M756077 dplr-rn 2018-09-17T18:17:36Z