topic Pivot table in QlikView https://community.qlik.com/t5/QlikView/Pivot-table/m-p/91425#M509604 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have a question- I need to create a pivot table for which I need to show &gt;30 days &gt;60days &gt;100 days (in rows)like that I need to show the count of those cases like[(50) in top column)and then If i expand near &gt;30days those case numbers(with count 50 display at the top) I need to show up same way in another &gt;60 days if I xepand it i need to show all the case numbers. In another cloumn I need to show avg and percentage too.please help. VEry urgent.</P></BODY></HTML> Tue, 30 Oct 2018 15:25:27 GMT Pujitha 2018-10-30T15:25:27Z Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/91425#M509604 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have a question- I need to create a pivot table for which I need to show &gt;30 days &gt;60days &gt;100 days (in rows)like that I need to show the count of those cases like[(50) in top column)and then If i expand near &gt;30days those case numbers(with count 50 display at the top) I need to show up same way in another &gt;60 days if I xepand it i need to show all the case numbers. In another cloumn I need to show avg and percentage too.please help. VEry urgent.</P></BODY></HTML> Tue, 30 Oct 2018 15:25:27 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/91425#M509604 Pujitha 2018-10-30T15:25:27Z Re: Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/91426#M509606 <HTML><HEAD></HEAD><BODY><P>i think you need to use valuelist</P><P>check below</P><P><A href="https://community.qlik.com/qlik-blogpost/3196">ValueList() – For those tricky situations</A></P></BODY></HTML> Tue, 30 Oct 2018 16:29:16 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/91426#M509606 dplr-rn 2018-10-30T16:29:16Z