topic Create income statement table with common size percentage in QlikView

topic Create income statement table with common size percentage in QlikView https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434873#M818639 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a set of raw data with format as below <table 1>. I'm wondering if there's anyway to create an income statement table with common size percentage as below <table 2>.</P><P></P><P>Thanks a lot!</P><P></P><P><Table 1>Raw data format</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Revenues</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Costs</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Expense</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">90</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">8</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">9</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">110</TD><TD style="padding: 2px;">35</TD><TD style="padding: 2px;">11</TD></TR></TBODY></TABLE><P></P><P><Table 2> Income statement table with common size%</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Number</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>Revenues</P></TD><TD style="padding: 2px;">300</TD><TD style="padding: 2px;">100%</TD></TR><TR><TD style="padding: 2px;">Costs</TD><TD style="padding: 2px;">80</TD><TD style="padding: 2px;">26.7%</TD></TR><TR><TD style="padding: 2px;">Gross</TD><TD style="padding: 2px;">220</TD><TD style="padding: 2px;">73.3%</TD></TR><TR><TD style="padding: 2px;">Expense</TD><TD style="padding: 2px;">28</TD><TD style="padding: 2px;">9.3%</TD></TR><TR><TD style="padding: 2px;">Profit</TD><TD style="padding: 2px;">192</TD><TD style="padding: 2px;">64%</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT katetsan 2020-11-25T16:16:04Z Create income statement table with common size percentage https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434873#M818639 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a set of raw data with format as below <table 1>. I'm wondering if there's anyway to create an income statement table with common size percentage as below <table 2>.</P><P></P><P>Thanks a lot!</P><P></P><P><Table 1>Raw data format</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Revenues</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Costs</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Expense</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">90</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">8</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">9</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">110</TD><TD style="padding: 2px;">35</TD><TD style="padding: 2px;">11</TD></TR></TBODY></TABLE><P></P><P><Table 2> Income statement table with common size%</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Number</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>Revenues</P></TD><TD style="padding: 2px;">300</TD><TD style="padding: 2px;">100%</TD></TR><TR><TD style="padding: 2px;">Costs</TD><TD style="padding: 2px;">80</TD><TD style="padding: 2px;">26.7%</TD></TR><TR><TD style="padding: 2px;">Gross</TD><TD style="padding: 2px;">220</TD><TD style="padding: 2px;">73.3%</TD></TR><TR><TD style="padding: 2px;">Expense</TD><TD style="padding: 2px;">28</TD><TD style="padding: 2px;">9.3%</TD></TR><TR><TD style="padding: 2px;">Profit</TD><TD style="padding: 2px;">192</TD><TD style="padding: 2px;">64%</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434873#M818639 katetsan 2020-11-25T16:16:04Z Re: Create income statement table with common size percentage https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434874#M818640 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try to use cross table method,</P><P>Data:</P><P>CrossTable(Type, Amount)</P><P>LOAD * INLINE [</P><P>    Item, Revenues, Costs, Expense</P><P>    A, 90, 20, 8</P><P>    B, 100, 25, 9</P><P>    C, 110, 35, 11</P><P>];</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/174014_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 21 Aug 2017 07:57:17 GMT https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434874#M818640 devarasu07 2017-08-21T07:57:17Z Re: Create income statement table with common size percentage https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434875#M818641 <HTML><HEAD></HEAD><BODY><P>Hi Devarasu,</P><P></P><P>Thanks for your reply.</P><P>However, there're over 1000 rows of data flow, it's hard to use load inline scripts.</P><P>In addition, the data flow is like the list of transaction without summary.</P><P>Is there any alternative suggestion?</P><P></P><P>Thanks a lot!</P></BODY></HTML> Mon, 21 Aug 2017 08:23:26 GMT https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434875#M818641 katetsan 2017-08-21T08:23:26Z Re: Create income statement table with common size percentage https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434876#M818642 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>You can use excel/other data source for your live report. using cross table method it should n off rows. give a try and let us know if any issue. Thanks</P></BODY></HTML> Mon, 21 Aug 2017 08:34:20 GMT https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434876#M818642 devarasu07 2017-08-21T08:34:20Z Re: Create income statement table with common size percentage https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434877#M818643 <HTML><HEAD></HEAD><BODY><P>May be check out this</P><P></P><P><A href="https://community.qlik.com/docs/DOC-3324">How to Create a Profit and Loss Statement in QlikView</A>‌</P><P><A href="https://community.qlik.com/qlik-blogpost/2701">How IntervalMatch Solved My Profit and Loss Dilemma</A></P></BODY></HTML> Mon, 21 Aug 2017 12:06:39 GMT https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434877#M818643 sunny_talwar 2017-08-21T12:06:39Z Re: Create income statement table with common size percentage https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434878#M818644 <HTML><HEAD></HEAD><BODY><P>Hi Kate,</P><P>You can get a straight table like this:</P><P></P><P>  </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192px;"><TBODY><TR><TD class="xl63" height="17" width="64">Category</TD><TD class="xl64" style="border-left: none;" width="64">Number</TD><TD class="xl64" style="border-left: none;" width="64">Header3</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Revenues</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">300</TD><TD class="xl66" style="border-top: none; border-left: none;" width="64">100%</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Costs</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">80</TD><TD class="xl67" style="border-top: none; border-left: none;" width="64">26.7%</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Gross</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">220</TD><TD class="xl67" style="border-top: none; border-left: none;" width="64">73.3%</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Expense</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">28</TD><TD class="xl67" style="border-top: none; border-left: none;" width="64">9.3%</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Profit</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">192</TD><TD class="xl67" style="border-top: none; border-left: none;" width="64">64.0%</TD></TR></TBODY></TABLE><P></P><P>The dimension <EM>Category</EM> is a calculated dimension:</P><P>=ValueList('Number','Header3')</P><P></P><P>These are the expressions:</P><P>Revenues:</P><P>Pick(Match(ValueList('Number','Header3'),'Number','Header3'),</P><P>Sum(Revenues),num(1,'0%'))</P><P></P><P>Costs:</P><P>Pick(Match(ValueList('Number','Header3'),'Number','Header3'),</P><P>Sum(Costs),num(Sum(Costs)/ Sum(Revenues),'0.0%'))</P><P></P><P>Gross:</P><P>Pick(Match(ValueList('Number','Header3'),'Number','Header3'),</P><P>Sum(Revenues)-Sum(Costs),num((Sum(Revenues)-Sum(Costs))/ Sum(Revenues),'0.0%'))</P><P></P><P>Expense:</P><P>Pick(Match(ValueList('Number','Header3'),'Number','Header3'),</P><P>Sum(Expense),num(Sum(Expense)/ Sum(Revenues),'0.0%'))</P><P></P><P>Profit:</P><P>Pick(Match(ValueList('Number','Header3'),'Number','Header3'),</P><P>Sum(Revenues)-Sum(Costs)-Sum(Expense),num((Sum(Revenues)-Sum(Costs)-Sum(Expense))/ Sum(Revenues),'0.0%'))</P><P></P><P>In the <EM>Presentation</EM> tab of the straight table check the <EM>Horizontal</EM> box.</P><P></P><P>good luck</P><P></P><P>Andrew</P></BODY></HTML> Mon, 21 Aug 2017 12:45:20 GMT https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434878#M818644 effinty2112 2017-08-21T12:45:20Z Re: Create income statement table with common size percentage https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434879#M818645 <HTML><HEAD></HEAD><BODY><P>Create one inline table in script</P><P></P><P><STRONG>1st method:</STRONG></P><P></P><P>LOAD * inline [</P><P>Dim</P><P>1</P><P>2</P><P>3</P><P>4</P><P>5 ];</P><P></P><P>create the straight table</P><P></P><P>Dimension:</P><P>Pick(Dim,'Revenues','Costs','Gross','Expense','Profit')</P><P></P><P>Expression:</P><P><STRONG>1) Number :</STRONG></P><P>Pick(Dim,</P><P>Sum(<SPAN style="font-size: 13.3333px;">Revenues),</SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Costs</SPAN></SPAN><SPAN style="font-size: 13.3333px;">),</SPAN></SPAN></P><P style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Revenues)-</SPAN><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Costs</SPAN></SPAN><SPAN style="font-size: 13.3333px;">),</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Expense</SPAN></SPAN><SPAN style="font-size: 13.3333px;">),</SPAN></SPAN></P><P style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Revenues)-</SPAN><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Costs</SPAN></SPAN><SPAN style="font-size: 13.3333px;">)-</SPAN><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Expense</SPAN></SPAN><SPAN style="font-size: 13.3333px;">))</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><STRONG>2) %</STRONG><BR /></SPAN></P><P style="font-size: 13.3333px;">Pick(Dim,</P><P style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Revenues)/<SPAN style="font-size: 13.3333px;">Sum(</SPAN><SPAN style="font-size: 13.3333px;">Revenues)</SPAN>,</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Costs</SPAN></SPAN><SPAN style="font-size: 13.3333px;">)/<SPAN style="font-size: 13.3333px;">Sum(</SPAN><SPAN style="font-size: 13.3333px;">Revenues)</SPAN>,</SPAN></SPAN></P><P style="font-size: 13.3333px;">(Sum(<SPAN style="font-size: 13.3333px;">Revenues)-</SPAN><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Costs</SPAN></SPAN><SPAN style="font-size: 13.3333px;">))/<SPAN style="font-size: 13.3333px;">Sum(</SPAN><SPAN style="font-size: 13.3333px;">Revenues)</SPAN>,</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Expense</SPAN></SPAN><SPAN style="font-size: 13.3333px;">)/<SPAN style="font-size: 13.3333px;">Sum(</SPAN><SPAN style="font-size: 13.3333px;">Revenues)</SPAN>,</SPAN></SPAN></P><P style="font-size: 13.3333px;">(Sum(<SPAN style="font-size: 13.3333px;">Revenues)-</SPAN><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Costs</SPAN></SPAN><SPAN style="font-size: 13.3333px;">)-</SPAN><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Expense</SPAN></SPAN><SPAN style="font-size: 13.3333px;">))/<SPAN style="font-size: 13.3333px;">Sum(</SPAN><SPAN style="font-size: 13.3333px;">Revenues)</SPAN>)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG>2nd method:</STRONG></SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG><BR /></STRONG></SPAN></P><P style="font-size: 13.3333px;">create the straight table</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Dimension:</P><P style="font-size: 13.3333px;">Valuelist('Revenues','Costs','Gross','Expense','Profit')</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Expression:</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><STRONG>1) Number :</STRONG></SPAN></P><P style="font-size: 13.3333px;">Pick(match(<SPAN style="font-size: 13.3333px;">Valuelist('Revenues','Costs','Gross','Expense','Profit')</SPAN>,<SPAN style="font-size: 13.3333px;">'Revenues','Costs','Gross','Expense','Profit'),</SPAN></P><P style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Revenues),</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Costs</SPAN></SPAN><SPAN style="font-size: 13.3333px;">),</SPAN></SPAN></P><P style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Revenues)-</SPAN><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Costs</SPAN></SPAN><SPAN style="font-size: 13.3333px;">),</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Expense</SPAN></SPAN><SPAN style="font-size: 13.3333px;">),</SPAN></SPAN></P><P style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Revenues)-</SPAN><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Costs</SPAN></SPAN><SPAN style="font-size: 13.3333px;">)-</SPAN><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Expense</SPAN></SPAN><SPAN style="font-size: 13.3333px;">))</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><STRONG>2) %</STRONG></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Pick(match(</SPAN><SPAN style="font-size: 13.3333px;">Valuelist('Revenues','Costs','Gross','Expense','Profit')</SPAN><SPAN style="font-size: 13.3333px;">,</SPAN><SPAN style="font-size: 13.3333px;">'Revenues','Costs','Gross','Expense','Profit'),</SPAN></P><P style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Revenues)/<SPAN style="font-size: 13.3333px;">Sum(</SPAN><SPAN style="font-size: 13.3333px;">Revenues)</SPAN>,</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Costs</SPAN></SPAN><SPAN style="font-size: 13.3333px;">)/<SPAN style="font-size: 13.3333px;">Sum(</SPAN><SPAN style="font-size: 13.3333px;">Revenues)</SPAN>,</SPAN></SPAN></P><P style="font-size: 13.3333px;">(Sum(<SPAN style="font-size: 13.3333px;">Revenues)-</SPAN><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Costs</SPAN></SPAN><SPAN style="font-size: 13.3333px;">))/<SPAN style="font-size: 13.3333px;">Sum(</SPAN><SPAN style="font-size: 13.3333px;">Revenues)</SPAN>,</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Expense</SPAN></SPAN><SPAN style="font-size: 13.3333px;">)/<SPAN style="font-size: 13.3333px;">Sum(</SPAN><SPAN style="font-size: 13.3333px;">Revenues)</SPAN>,</SPAN></SPAN></P><P style="font-size: 13.3333px;">(Sum(<SPAN style="font-size: 13.3333px;">Revenues)-</SPAN><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Costs</SPAN></SPAN><SPAN style="font-size: 13.3333px;">)-</SPAN><SPAN style="font-size: 13.3333px;">Sum(<SPAN style="font-size: 13.3333px;">Expense</SPAN></SPAN><SPAN style="font-size: 13.3333px;">))/<SPAN style="font-size: 13.3333px;">Sum(</SPAN><SPAN style="font-size: 13.3333px;">Revenues)</SPAN>)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P></P><P>Note: for % expression, go to chart properties->Number tab -> check Fixed to 1 and check show in % option</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Update: Updated % expression<BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><STRONG><BR /></STRONG></SPAN></P></BODY></HTML> Mon, 21 Aug 2017 12:56:08 GMT https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434879#M818645 Kushal_Chawda 2017-08-21T12:56:08Z Re: Create income statement table with common size percentage https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434880#M818646 <HTML><HEAD></HEAD><BODY><P>Updated expression in my OP</P></BODY></HTML> Mon, 21 Aug 2017 13:02:27 GMT https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434880#M818646 Kushal_Chawda 2017-08-21T13:02:27Z Re: Create income statement table with common size percentage https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434881#M818647 <HTML><HEAD></HEAD><BODY><P>Hi Kushal,</P><P></P><P>It works perfectly. Thanks a lot!</P></BODY></HTML> Tue, 22 Aug 2017 03:32:27 GMT https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434881#M818647 katetsan 2017-08-22T03:32:27Z Re: Create income statement table with common size percentage https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434882#M818648 <HTML><HEAD></HEAD><BODY><P>Hi Andrew,</P><P></P><P>It works !! Thanks A LOT!!!</P></BODY></HTML> Tue, 22 Aug 2017 03:33:03 GMT https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434882#M818648 katetsan 2017-08-22T03:33:03Z Re: Create income statement table with common size percentage https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434883#M818649 <HTML><HEAD></HEAD><BODY><P>Please mark the answer as correct, so that others can refer if they faced the same problem</P></BODY></HTML> Tue, 22 Aug 2017 08:44:10 GMT https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size-percentage/m-p/1434883#M818649 Kushal_Chawda 2017-08-22T08:44:10Z