topic Chart in Search the Community https://community.qlik.com/t5/Search-the-Community/Chart/m-p/1812549#M345 <P>Dear all,</P><P>I want below format in QlikView Pivot Table</P><P>1)Here&nbsp; <STRONG>APR 2020 </STRONG>to <STRONG>Apr-2021 Month Values&nbsp;</STRONG>and&nbsp; <STRONG>YTD MAR-2021 </STRONG>and <STRONG>FY 20 are </STRONG>expressions</P><P>how to get simple way to achieve this instead of writing 42 expressions&nbsp;&nbsp;please help me for this.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><STRONG>APR 2020</STRONG></TD><TD><STRONG>MAY 2020</STRONG></TD><TD><STRONG>JUN 2020</STRONG></TD><TD><STRONG>JUL 2020</STRONG></TD><TD><STRONG>AUG 2020</STRONG></TD><TD><STRONG>SEP 2020</STRONG></TD><TD><STRONG>OCT 2020</STRONG></TD><TD><STRONG>Nov 2020</STRONG></TD><TD><STRONG>Dec 2020</STRONG></TD><TD><STRONG>Jan-2021</STRONG></TD><TD><STRONG>Feb-21</STRONG></TD><TD><STRONG>Mar-2021</STRONG></TD><TD><STRONG>Apr-2021</STRONG></TD><TD><STRONG>YTD MAR-2021</STRONG></TD><TD><STRONG>FY 20</STRONG></TD></TR><TR><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD></TR></TBODY></TABLE> Wed, 02 Jun 2021 19:56:04 GMT sreenivasareddy 2021-06-02T19:56:04Z Chart https://community.qlik.com/t5/Search-the-Community/Chart/m-p/1812549#M345 <P>Dear all,</P><P>I want below format in QlikView Pivot Table</P><P>1)Here&nbsp; <STRONG>APR 2020 </STRONG>to <STRONG>Apr-2021 Month Values&nbsp;</STRONG>and&nbsp; <STRONG>YTD MAR-2021 </STRONG>and <STRONG>FY 20 are </STRONG>expressions</P><P>how to get simple way to achieve this instead of writing 42 expressions&nbsp;&nbsp;please help me for this.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><STRONG>APR 2020</STRONG></TD><TD><STRONG>MAY 2020</STRONG></TD><TD><STRONG>JUN 2020</STRONG></TD><TD><STRONG>JUL 2020</STRONG></TD><TD><STRONG>AUG 2020</STRONG></TD><TD><STRONG>SEP 2020</STRONG></TD><TD><STRONG>OCT 2020</STRONG></TD><TD><STRONG>Nov 2020</STRONG></TD><TD><STRONG>Dec 2020</STRONG></TD><TD><STRONG>Jan-2021</STRONG></TD><TD><STRONG>Feb-21</STRONG></TD><TD><STRONG>Mar-2021</STRONG></TD><TD><STRONG>Apr-2021</STRONG></TD><TD><STRONG>YTD MAR-2021</STRONG></TD><TD><STRONG>FY 20</STRONG></TD></TR><TR><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD><TD><STRONG>Base</STRONG></TD><TD><STRONG>Ach</STRONG></TD><TD><STRONG>Conv%</STRONG></TD></TR></TBODY></TABLE> Wed, 02 Jun 2021 19:56:04 GMT https://community.qlik.com/t5/Search-the-Community/Chart/m-p/1812549#M345 sreenivasareddy 2021-06-02T19:56:04Z