topic Add new row to PivotTable in QlikView https://community.qlik.com/t5/QlikView/Add-new-row-to-PivotTable/m-p/1457896#M512063 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i am new in Qliksense and i have a question and sorry for my bad english. I hope you can understand my problem <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>I create a Pivot-Table from my Database - like this:</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/188677_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P>The Table shows me the ticket-Count from state closed, merged and so on...</P><P></P><P>Now i need a new line below the incident, called "Quote" -&nbsp; like this (created in excel):</P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/188681_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>The Data from the new line:</P><P>SUM total / SUM from the state closed and merged (and removed) -&gt; As Percent</P><P></P><P>How can i do this?</P><P>Do you need further informations? Please ask me <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Thx for your help...</P></BODY></HTML> Wed, 03 Jan 2018 09:58:36 GMT Anonymous 2018-01-03T09:58:36Z Add new row to PivotTable https://community.qlik.com/t5/QlikView/Add-new-row-to-PivotTable/m-p/1457896#M512063 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i am new in Qliksense and i have a question and sorry for my bad english. I hope you can understand my problem <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>I create a Pivot-Table from my Database - like this:</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/188677_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P>The Table shows me the ticket-Count from state closed, merged and so on...</P><P></P><P>Now i need a new line below the incident, called "Quote" -&nbsp; like this (created in excel):</P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/188681_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>The Data from the new line:</P><P>SUM total / SUM from the state closed and merged (and removed) -&gt; As Percent</P><P></P><P>How can i do this?</P><P>Do you need further informations? Please ask me <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Thx for your help...</P></BODY></HTML> Wed, 03 Jan 2018 09:58:36 GMT https://community.qlik.com/t5/QlikView/Add-new-row-to-PivotTable/m-p/1457896#M512063 Anonymous 2018-01-03T09:58:36Z Re: Add new row to PivotTable https://community.qlik.com/t5/QlikView/Add-new-row-to-PivotTable/m-p/1457897#M512064 <HTML><HEAD></HEAD><BODY><P>This is a quite similar case: <A href="https://community.qlik.com/message/1338367">Re: Row percent for subtotals in pivot table Qlik Sense</A> in which a further dimension is used with an check on the dimensionality(). If you don't want to create such a main-category for your Incidents you will need to add Quote as a field-value to Incidents and then query this field-value to make your quotes-expression or for the summing-expression.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 03 Jan 2018 13:13:15 GMT https://community.qlik.com/t5/QlikView/Add-new-row-to-PivotTable/m-p/1457897#M512064 marcus_sommer 2018-01-03T13:13:15Z