topic Re: pivot table in QlikView https://community.qlik.com/t5/QlikView/pivot-table/m-p/1046037#M351638 <HTML><HEAD></HEAD><BODY><P>Only showing the output in itself isn't very helpful. A good post is a one which contain description of what is needed, some data inputs and an expected output. I am not sure how are you getting any of the numbers in your screenshot. Please provide some more details and a sample if possible.</P></BODY></HTML> Sun, 28 Feb 2016 17:23:28 GMT sunny_talwar 2016-02-28T17:23:28Z pivot table https://community.qlik.com/t5/QlikView/pivot-table/m-p/1046036#M351637 <HTML><HEAD></HEAD><BODY><P>Hi Guru's,</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">We are using pivot table ,I wanted to show % of below repo row.I haver tied calculated dimension but it's not working.Any suggestion.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Ex: Total/Open/O/N,Total/1week percentages etc..............<BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"> attached is the screen shot.</SPAN></P><P></P><P>-Sateesh</P></BODY></HTML> Sun, 28 Feb 2016 17:11:25 GMT https://community.qlik.com/t5/QlikView/pivot-table/m-p/1046036#M351637 sat_tok52 2016-02-28T17:11:25Z Re: pivot table https://community.qlik.com/t5/QlikView/pivot-table/m-p/1046037#M351638 <HTML><HEAD></HEAD><BODY><P>Only showing the output in itself isn't very helpful. A good post is a one which contain description of what is needed, some data inputs and an expected output. I am not sure how are you getting any of the numbers in your screenshot. Please provide some more details and a sample if possible.</P></BODY></HTML> Sun, 28 Feb 2016 17:23:28 GMT https://community.qlik.com/t5/QlikView/pivot-table/m-p/1046037#M351638 sunny_talwar 2016-02-28T17:23:28Z Re: pivot table https://community.qlik.com/t5/QlikView/pivot-table/m-p/1046038#M351639 <HTML><HEAD></HEAD><BODY><P>Would be easier to answer if you provide dimensions and expressions used, just like you need to define on dimension and expression tab in your chart.</P><P></P><P>If you used an expression like</P><P>=Count(ID)</P><P></P><P>You can maybe get your percentages using TOTAL qualifier with a field dimension list, maybe like</P><P></P><P>= num( <STRONG>Count(ID) / Count(<EM>TOTAL&lt;repo&gt;</EM> ID)</STRONG>, '#0.0%', '.', ',')</P></BODY></HTML> Sun, 28 Feb 2016 17:23:49 GMT https://community.qlik.com/t5/QlikView/pivot-table/m-p/1046038#M351639 swuehl 2016-02-28T17:23:49Z