topic Re: Pivot table expressions in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-expressions/m-p/1299427#M843115 <HTML><HEAD></HEAD><BODY><P>Something like the attached?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/159724_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 11 Apr 2017 11:07:36 GMT sunny_talwar 2017-04-11T11:07:36Z Pivot table expressions https://community.qlik.com/t5/QlikView/Pivot-table-expressions/m-p/1299425#M843113 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a pivot table with 2 dimensions, Domain and Region. I have transposed one of the dimensions,Region. I earlier had only 1 expression(sales). There is a new requirement now to show the count of records for every domain(not region). How can I acheive this</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" 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: 379px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Domain</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Area1</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Area2</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Area3</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Count by Domain </TH></TR><TR><TD height="19" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Retail</TD><TD class="xl65" 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 class="xl65" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">32</TD><TD class="xl65" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">12</TD><TD class="xl67" 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 height="19" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Pharmacy</TD><TD class="xl65" 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 class="xl65" 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 class="xl65" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">11</TD><TD class="xl67" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">12</TD></TR><TR><TD height="19" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Banking</TD><TD class="xl65" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">22</TD><TD class="xl65" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">33</TD><TD class="xl65" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">44</TD><TD class="xl67" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"><P>14</P></TD></TR></TBODY></TABLE><P></P><P>Please let me know. !</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Pivot-table-expressions/m-p/1299425#M843113 Anonymous 2020-11-25T16:16:04Z Re: Pivot table expressions https://community.qlik.com/t5/QlikView/Pivot-table-expressions/m-p/1299426#M843114 <HTML><HEAD></HEAD><BODY><P>Can share what is expected result?</P><P></P><P></P><P>-Nagarjun</P></BODY></HTML> Tue, 11 Apr 2017 11:04:07 GMT https://community.qlik.com/t5/QlikView/Pivot-table-expressions/m-p/1299426#M843114 nagarjuna_kotha 2017-04-11T11:04:07Z Re: Pivot table expressions https://community.qlik.com/t5/QlikView/Pivot-table-expressions/m-p/1299427#M843115 <HTML><HEAD></HEAD><BODY><P>Something like the attached?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/159724_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 11 Apr 2017 11:07:36 GMT https://community.qlik.com/t5/QlikView/Pivot-table-expressions/m-p/1299427#M843115 sunny_talwar 2017-04-11T11:07:36Z