topic Please help me out on pivot function. in QlikView https://community.qlik.com/t5/QlikView/Please-help-me-out-on-pivot-function/m-p/133654#M764011 <HTML><HEAD></HEAD><BODY><P>To whom it may concern,</P><P></P><P>It would be highly appreciated if you could help me to draw a pivot table in a sheet.</P><P></P><P>There is an Excel pivot table with 100 columns and 300 rows.&nbsp; It contains 100 students' test scores by date and some of them are listed unchronologically.&nbsp; By now, I learned to unpivot the table in order to draw a graph to see students' progress.</P><P></P><P>I have two questions.</P><P>Q1.</P><P>Could you please show me how to choose the items when unpivoting the table?&nbsp; There are like 200 items from 300 rows and wanted to select the right items and order them.&nbsp; Now I am using shift key to choose muptiple items one by one including unnecessary items.&nbsp; Is it easy to delete the wrong items from an unpivoted table?</P><P></P><P>Q2.</P><P>I would like to have a pivot table in a sheet view alongside the graph.&nbsp; I have a problem to create a pivot table.&nbsp; It would be highly appreciated if you could take a look at the attached with less valuables.</P><P></P><P>Thank you very much for your assistance in advance.</P><P></P><P>With gratitude,</P><P>Masako</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Please help me out on pivot function. https://community.qlik.com/t5/QlikView/Please-help-me-out-on-pivot-function/m-p/133654#M764011 <HTML><HEAD></HEAD><BODY><P>To whom it may concern,</P><P></P><P>It would be highly appreciated if you could help me to draw a pivot table in a sheet.</P><P></P><P>There is an Excel pivot table with 100 columns and 300 rows.&nbsp; It contains 100 students' test scores by date and some of them are listed unchronologically.&nbsp; By now, I learned to unpivot the table in order to draw a graph to see students' progress.</P><P></P><P>I have two questions.</P><P>Q1.</P><P>Could you please show me how to choose the items when unpivoting the table?&nbsp; There are like 200 items from 300 rows and wanted to select the right items and order them.&nbsp; Now I am using shift key to choose muptiple items one by one including unnecessary items.&nbsp; Is it easy to delete the wrong items from an unpivoted table?</P><P></P><P>Q2.</P><P>I would like to have a pivot table in a sheet view alongside the graph.&nbsp; I have a problem to create a pivot table.&nbsp; It would be highly appreciated if you could take a look at the attached with less valuables.</P><P></P><P>Thank you very much for your assistance in advance.</P><P></P><P>With gratitude,</P><P>Masako</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Please-help-me-out-on-pivot-function/m-p/133654#M764011 Anonymous 2020-11-25T16:16:04Z