topic Pivot Presentation in New to QlikViewhttps://community.qlik.com/t5/New-to-QlikView/Pivot-Presentation/m-p/1676720#M386624
<P>Dear Community,</P><P>i need to create a pivot-table like shown below. Every KPI is a formula and the columns "Last Year", "Actual Year" and "PLAN" describes the set expression.&nbsp; For example we will have a closer look on the KPI "Revenue"</P><P>Revenue = Sum(Sales)</P><P>Revenue Last Year = Sum({&lt; Year = {'LY'}&gt;} and so on.</P><P>How to implement?&nbsp; Any suggestions?</P><P>&nbsp;</P><TABLE width="423px"><TBODY><TR><TD width="136px">KPI</TD><TD width="96px">Last Year</TD><TD width="115px">Acutal Year</TD><TD width="75px">PLAN</TD></TR><TR><TD width="136px">Revenue</TD><TD width="96px">&nbsp;</TD><TD width="115px">&nbsp;</TD><TD width="75px">&nbsp;</TD></TR><TR><TD width="136px">Order value</TD><TD width="96px">&nbsp;</TD><TD width="115px">&nbsp;</TD><TD width="75px">&nbsp;</TD></TR><TR><TD width="136px">On Time Delivery</TD><TD width="96px">&nbsp;</TD><TD width="115px">&nbsp;</TD><TD width="75px">&nbsp;</TD></TR></TBODY></TABLE>Tue, 18 Feb 2020 15:06:32 GMTfhinland_12020-02-18T15:06:32ZPivot Presentationhttps://community.qlik.com/t5/New-to-QlikView/Pivot-Presentation/m-p/1676720#M386624
<P>Dear Community,</P><P>i need to create a pivot-table like shown below. Every KPI is a formula and the columns "Last Year", "Actual Year" and "PLAN" describes the set expression.&nbsp; For example we will have a closer look on the KPI "Revenue"</P><P>Revenue = Sum(Sales)</P><P>Revenue Last Year = Sum({&lt; Year = {'LY'}&gt;} and so on.</P><P>How to implement?&nbsp; Any suggestions?</P><P>&nbsp;</P><TABLE width="423px"><TBODY><TR><TD width="136px">KPI</TD><TD width="96px">Last Year</TD><TD width="115px">Acutal Year</TD><TD width="75px">PLAN</TD></TR><TR><TD width="136px">Revenue</TD><TD width="96px">&nbsp;</TD><TD width="115px">&nbsp;</TD><TD width="75px">&nbsp;</TD></TR><TR><TD width="136px">Order value</TD><TD width="96px">&nbsp;</TD><TD width="115px">&nbsp;</TD><TD width="75px">&nbsp;</TD></TR><TR><TD width="136px">On Time Delivery</TD><TD width="96px">&nbsp;</TD><TD width="115px">&nbsp;</TD><TD width="75px">&nbsp;</TD></TR></TBODY></TABLE>Tue, 18 Feb 2020 15:06:32 GMThttps://community.qlik.com/t5/New-to-QlikView/Pivot-Presentation/m-p/1676720#M386624fhinland_12020-02-18T15:06:32ZRe: Pivot Presentationhttps://community.qlik.com/t5/New-to-QlikView/Pivot-Presentation/m-p/1687434#M387637
<P>In order to get a response on posts like these, you generally need to submit some raw data so folks have something to work with, otherwise more than a little difficult trying to explain how to script things etc.&nbsp; One place you can look around for examples of things is the Design Blog area of the Community, that may provide some ideas on how to go about things to the point you can get a working QVW you can then attach to ask for help in solving any final issues...</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog</A></P><P>Regards,<BR />Brett</P>Tue, 24 Mar 2020 18:51:17 GMThttps://community.qlik.com/t5/New-to-QlikView/Pivot-Presentation/m-p/1687434#M387637Brett_Bleess2020-03-24T18:51:17Z