topic Need to create report from pivot format in App Development

topic Need to create report from pivot format in App Development https://community.qlik.com/t5/App-Development/Need-to-create-report-from-pivot-format/m-p/2532332#M108099 <P>Hi,</P> <P>Need help to create report from pivot table format.</P> <P>Having date is in below format.</P> <TABLE width="984"> <TBODY> <TR> <TD width="115">Market</TD> <TD width="115">City</TD> <TD width="115">City ID</TD> <TD width="115">YearMonth</TD> <TD width="115">Value</TD> <TD width="115">#  Number</TD> <TD width="115">Value</TD> <TD width="115">#  Number</TD> <TD width="64"> </TD> </TR> <TR> <TD rowspan="15"> Market A</TD> <TD rowspan="10">city1</TD> <TD rowspan="10">3030</TD> <TD>202206</TD> <TD>3459</TD> <TD>1</TD> <TD>76567.66</TD> <TD>11</TD> <TD> </TD> </TR> <TR> <TD>202207</TD> <TD>4646</TD> <TD>2</TD> <TD>7476565.9</TD> <TD>22</TD> <TD> </TD> </TR> <TR> <TD>202208</TD> <TD>5833</TD> <TD>3</TD> <TD>14876564.14</TD> <TD>33</TD> <TD> </TD> </TR> <TR> <TD>202209</TD> <TD>7020</TD> <TD>4</TD> <TD>22276562.38</TD> <TD>44</TD> <TD> </TD> </TR> <TR> <TD>202210</TD> <TD>8207</TD> <TD>5</TD> <TD>29676560.62</TD> <TD>55</TD> <TD> </TD> </TR> <TR> <TD>202211</TD> <TD>9394</TD> <TD>6</TD> <TD>37076558.86</TD> <TD>66</TD> <TD> </TD> </TR> <TR> <TD>202212</TD> <TD>10581</TD> <TD>7</TD> <TD>44476557.1</TD> <TD>77</TD> <TD> </TD> </TR> <TR> <TD>202304</TD> <TD>15329</TD> <TD>11</TD> <TD>74076550.06</TD> <TD>121</TD> <TD> </TD> </TR> <TR> <TD>202305</TD> <TD>16516</TD> <TD>12</TD> <TD>81476548.3</TD> <TD>132</TD> <TD> </TD> </TR> <TR> <TD>202306</TD> <TD>17703</TD> <TD>13</TD> <TD>88876546.54</TD> <TD>143</TD> <TD> </TD> </TR> <TR> <TD rowspan="5">city 2</TD> <TD rowspan="5">2020</TD> <TD>202302</TD> <TD>28386</TD> <TD>22</TD> <TD>155476530.7</TD> <TD>242</TD> <TD> </TD> </TR> <TR> <TD>202303</TD> <TD>29573</TD> <TD>23</TD> <TD>162876528.9</TD> <TD>253</TD> <TD> </TD> </TR> <TR> <TD>202304</TD> <TD>30760</TD> <TD>24</TD> <TD>170276527.2</TD> <TD>264</TD> <TD> </TD> </TR> <TR> <TD>202305</TD> <TD>31947</TD> <TD>25</TD> <TD>177676525.4</TD> <TD>275</TD> <TD> </TD> </TR> <TR> <TD>202306</TD> <TD>33134</TD> <TD>26</TD> <TD>185076523.7</TD> <TD>286</TD> <TD> </TD> </TR> </TBODY> </TABLE> <P>Need to create report in below format.</P> <TABLE width="920"> <TBODY> <TR> <TD width="115">Market</TD> <TD width="115">City</TD> <TD width="115">City ID</TD> <TD width="115">YearMonth</TD> <TD width="115">Feedback Code</TD> <TD width="115">Feedback</TD> <TD width="115">Value</TD> <TD width="115">#  Number</TD> </TR> <TR> <TD width="115"> </TD> <TD width="115"> </TD> <TD width="115"> </TD> <TD width="115">202206</TD> <TD width="115">C1</TD> <TD width="115">satisfaction</TD> <TD>3459</TD> <TD>1</TD> </TR> <TR> <TD width="115"> </TD> <TD width="115"> </TD> <TD width="115"> </TD> <TD width="115"> </TD> <TD width="115">C2</TD> <TD colspan="2">76567.66</TD> <TD width="115">11</TD> </TR> </TBODY> </TABLE> Thu, 02 Oct 2025 12:10:03 GMT asaradkar_2609 2025-10-02T12:10:03Z Need to create report from pivot format https://community.qlik.com/t5/App-Development/Need-to-create-report-from-pivot-format/m-p/2532332#M108099 <P>Hi,</P> <P>Need help to create report from pivot table format.</P> <P>Having date is in below format.</P> <TABLE width="984"> <TBODY> <TR> <TD width="115">Market</TD> <TD width="115">City</TD> <TD width="115">City ID</TD> <TD width="115">YearMonth</TD> <TD width="115">Value</TD> <TD width="115">#  Number</TD> <TD width="115">Value</TD> <TD width="115">#  Number</TD> <TD width="64"> </TD> </TR> <TR> <TD rowspan="15"> Market A</TD> <TD rowspan="10">city1</TD> <TD rowspan="10">3030</TD> <TD>202206</TD> <TD>3459</TD> <TD>1</TD> <TD>76567.66</TD> <TD>11</TD> <TD> </TD> </TR> <TR> <TD>202207</TD> <TD>4646</TD> <TD>2</TD> <TD>7476565.9</TD> <TD>22</TD> <TD> </TD> </TR> <TR> <TD>202208</TD> <TD>5833</TD> <TD>3</TD> <TD>14876564.14</TD> <TD>33</TD> <TD> </TD> </TR> <TR> <TD>202209</TD> <TD>7020</TD> <TD>4</TD> <TD>22276562.38</TD> <TD>44</TD> <TD> </TD> </TR> <TR> <TD>202210</TD> <TD>8207</TD> <TD>5</TD> <TD>29676560.62</TD> <TD>55</TD> <TD> </TD> </TR> <TR> <TD>202211</TD> <TD>9394</TD> <TD>6</TD> <TD>37076558.86</TD> <TD>66</TD> <TD> </TD> </TR> <TR> <TD>202212</TD> <TD>10581</TD> <TD>7</TD> <TD>44476557.1</TD> <TD>77</TD> <TD> </TD> </TR> <TR> <TD>202304</TD> <TD>15329</TD> <TD>11</TD> <TD>74076550.06</TD> <TD>121</TD> <TD> </TD> </TR> <TR> <TD>202305</TD> <TD>16516</TD> <TD>12</TD> <TD>81476548.3</TD> <TD>132</TD> <TD> </TD> </TR> <TR> <TD>202306</TD> <TD>17703</TD> <TD>13</TD> <TD>88876546.54</TD> <TD>143</TD> <TD> </TD> </TR> <TR> <TD rowspan="5">city 2</TD> <TD rowspan="5">2020</TD> <TD>202302</TD> <TD>28386</TD> <TD>22</TD> <TD>155476530.7</TD> <TD>242</TD> <TD> </TD> </TR> <TR> <TD>202303</TD> <TD>29573</TD> <TD>23</TD> <TD>162876528.9</TD> <TD>253</TD> <TD> </TD> </TR> <TR> <TD>202304</TD> <TD>30760</TD> <TD>24</TD> <TD>170276527.2</TD> <TD>264</TD> <TD> </TD> </TR> <TR> <TD>202305</TD> <TD>31947</TD> <TD>25</TD> <TD>177676525.4</TD> <TD>275</TD> <TD> </TD> </TR> <TR> <TD>202306</TD> <TD>33134</TD> <TD>26</TD> <TD>185076523.7</TD> <TD>286</TD> <TD> </TD> </TR> </TBODY> </TABLE> <P>Need to create report in below format.</P> <TABLE width="920"> <TBODY> <TR> <TD width="115">Market</TD> <TD width="115">City</TD> <TD width="115">City ID</TD> <TD width="115">YearMonth</TD> <TD width="115">Feedback Code</TD> <TD width="115">Feedback</TD> <TD width="115">Value</TD> <TD width="115">#  Number</TD> </TR> <TR> <TD width="115"> </TD> <TD width="115"> </TD> <TD width="115"> </TD> <TD width="115">202206</TD> <TD width="115">C1</TD> <TD width="115">satisfaction</TD> <TD>3459</TD> <TD>1</TD> </TR> <TR> <TD width="115"> </TD> <TD width="115"> </TD> <TD width="115"> </TD> <TD width="115"> </TD> <TD width="115">C2</TD> <TD colspan="2">76567.66</TD> <TD width="115">11</TD> </TR> </TBODY> </TABLE> Thu, 02 Oct 2025 12:10:03 GMT https://community.qlik.com/t5/App-Development/Need-to-create-report-from-pivot-format/m-p/2532332#M108099 asaradkar_2609 2025-10-02T12:10:03Z Re: Need to create report from pivot format https://community.qlik.com/t5/App-Development/Need-to-create-report-from-pivot-format/m-p/2532346#M108100 <P>How did you get the Satisfaction value?</P><P> </P><P>Achievable perhaps but needs some work in script.</P><P>Can you provide the data and rules?</P> Thu, 02 Oct 2025 14:52:01 GMT https://community.qlik.com/t5/App-Development/Need-to-create-report-from-pivot-format/m-p/2532346#M108100 robert_mika 2025-10-02T14:52:01Z