topic Re: How to bring calculated fields under one dimension in QlikView https://community.qlik.com/t5/QlikView/How-to-bring-calculated-fields-under-one-dimension/m-p/1211298#M877292 <HTML><HEAD></HEAD><BODY><P>What are the A &amp; B - Do you mean A is Admin and B is HR Values / What</P></BODY></HTML> Mon, 24 Oct 2016 04:47:21 GMT Anil_Babu_Samineni 2016-10-24T04:47:21Z How to bring calculated fields under one dimension https://community.qlik.com/t5/QlikView/How-to-bring-calculated-fields-under-one-dimension/m-p/1211296#M877290 <HTML><HEAD></HEAD><BODY><P>Hi Everyone, </P><P>Following is a sample of a template that i want to develop - </P><P>&nbsp;&nbsp; </P><TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="width: 515px; border-width: 1px; border-style: solid;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px; font-family: arial, helvetica, sans-serif; vertical-align: baseline;">PL Mapping</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px; font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Currency Value for Admin</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px; font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Currency Value for HR</TH></TR><TR><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Interest (A)</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">123</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">445</TD></TR><TR><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">FTP Expense (B)</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">456</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">123</TD></TR><TR><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"><STRONG>Net Interest Income (A + B)</STRONG></TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">579</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">568</TD></TR><TR><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">FEI</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">23</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">87</TD></TR><TR><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">ACBD</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">34</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">86</TD></TR><TR><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">FTE</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">45</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">43</TD></TR><TR><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Non-FTE</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">56</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">21</TD></TR><TR><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"><STRONG>Non Funded Income (NFI)</STRONG></TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">158</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">237</TD></TR><TR><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"><STRONG>Total Income (NII + NFI)</STRONG></TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">737</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">805</TD></TR><TR><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Provision</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">78</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">78</TD></TR><TR><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Realized</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">98</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">98</TD></TR><TR><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Non-Realized</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">10</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">10</TD></TR><TR><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"><STRONG>Total Segment </STRONG></TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">186</TD><TD align="right" class="xl64" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">186</TD></TR></TBODY></TABLE><P></P><P>I am having the dimension as PL Mapping which is given below - </P><P>&nbsp; </P><TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 177px; border-width: 1px; border-style: solid;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">PL Mapping</TH></TR><TR><TD class="xl66" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Interest (A)</TD></TR><TR><TD class="xl66" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">FTP Expense (B)</TD></TR><TR><TD class="xl66" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">FEI</TD></TR><TR><TD class="xl66" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">ACBD</TD></TR><TR><TD class="xl66" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">FTE</TD></TR><TR><TD class="xl66" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Non-FTE</TD></TR><TR><TD class="xl66" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Provision</TD></TR><TR><TD class="xl66" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Realized</TD></TR><TR><TD class="xl66" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Non-Realized</TD></TR></TBODY></TABLE><P></P><P>I would like to add these Calculated fields in my dimension column which are mentioned below - </P><P>&nbsp; </P><TABLE border="1px" cellpadding="0" cellspacing="0" height="115" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 191px; border-width: 1px; border-style: solid; height: 120px;" width="189"><TBODY><TR><TD class="xl65" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;" width="169"><STRONG>Net Interest Income (A + B)</STRONG></TD></TR><TR><TD class="xl66" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"><STRONG>Non Funded Income (NFI)</STRONG></TD></TR><TR><TD class="xl66" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"><STRONG>Total Income (NII + NFI)</STRONG></TD></TR><TR><TD class="xl66" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"><STRONG>Total Segment </STRONG></TD></TR></TBODY></TABLE><P>Can anyone please help me in how can i achieve this ?</P><P>Thanks in advance!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-bring-calculated-fields-under-one-dimension/m-p/1211296#M877290 2020-11-25T16:16:04Z Re: How to bring calculated fields under one dimension https://community.qlik.com/t5/QlikView/How-to-bring-calculated-fields-under-one-dimension/m-p/1211297#M877291 <HTML><HEAD></HEAD><BODY><P>pick(match())</P></BODY></HTML> Mon, 24 Oct 2016 04:46:01 GMT https://community.qlik.com/t5/QlikView/How-to-bring-calculated-fields-under-one-dimension/m-p/1211297#M877291 varshavig12 2016-10-24T04:46:01Z Re: How to bring calculated fields under one dimension https://community.qlik.com/t5/QlikView/How-to-bring-calculated-fields-under-one-dimension/m-p/1211298#M877292 <HTML><HEAD></HEAD><BODY><P>What are the A &amp; B - Do you mean A is Admin and B is HR Values / What</P></BODY></HTML> Mon, 24 Oct 2016 04:47:21 GMT https://community.qlik.com/t5/QlikView/How-to-bring-calculated-fields-under-one-dimension/m-p/1211298#M877292 Anil_Babu_Samineni 2016-10-24T04:47:21Z Re: How to bring calculated fields under one dimension https://community.qlik.com/t5/QlikView/How-to-bring-calculated-fields-under-one-dimension/m-p/1211299#M877293 <HTML><HEAD></HEAD><BODY><P>Have a look at : <A href="https://community.qlik.com/docs/DOC-3324">How to Create a Profit and Loss Statement in QlikView</A></P></BODY></HTML> Mon, 24 Oct 2016 04:52:34 GMT https://community.qlik.com/t5/QlikView/How-to-bring-calculated-fields-under-one-dimension/m-p/1211299#M877293 tresB 2016-10-24T04:52:34Z Re: How to bring calculated fields under one dimension https://community.qlik.com/t5/QlikView/How-to-bring-calculated-fields-under-one-dimension/m-p/1211300#M877294 <HTML><HEAD></HEAD><BODY><P>You can try this:</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/141651_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 24 Oct 2016 05:38:06 GMT https://community.qlik.com/t5/QlikView/How-to-bring-calculated-fields-under-one-dimension/m-p/1211300#M877294 varshavig12 2016-10-24T05:38:06Z Re: How to bring calculated fields under one dimension https://community.qlik.com/t5/QlikView/How-to-bring-calculated-fields-under-one-dimension/m-p/1211301#M877295 <HTML><HEAD></HEAD><BODY><P>This made me understand how it will work.</P><P>Thanks </P></BODY></HTML> Mon, 24 Oct 2016 19:23:00 GMT https://community.qlik.com/t5/QlikView/How-to-bring-calculated-fields-under-one-dimension/m-p/1211301#M877295 2016-10-24T19:23:00Z