topic First row in a straight table in QlikView https://community.qlik.com/t5/QlikView/First-row-in-a-straight-table/m-p/368485#M1172572 <HTML><HEAD></HEAD><BODY><P>I have a physicianwise table.Dimiension is Physcian name.Expression in sum(volume)</P><P></P><P>But in this First row I need Nationwise volumn.</P><P>Second row I need regionwise volumn</P><P></P><P></P><P></P><P></P><P><IMG __jive_id="18897" class="jive-image" alt="screen_shot1.jpg" src="https://community.qlik.com/legacyfs/online/18897_screen_shot1.jpg" /></P><P></P><P>Thanks</P><P>Sibin</P></BODY></HTML> Thu, 26 Jul 2012 06:45:42 GMT sibin_jacob 2012-07-26T06:45:42Z First row in a straight table https://community.qlik.com/t5/QlikView/First-row-in-a-straight-table/m-p/368485#M1172572 <HTML><HEAD></HEAD><BODY><P>I have a physicianwise table.Dimiension is Physcian name.Expression in sum(volume)</P><P></P><P>But in this First row I need Nationwise volumn.</P><P>Second row I need regionwise volumn</P><P></P><P></P><P></P><P></P><P><IMG __jive_id="18897" class="jive-image" alt="screen_shot1.jpg" src="https://community.qlik.com/legacyfs/online/18897_screen_shot1.jpg" /></P><P></P><P>Thanks</P><P>Sibin</P></BODY></HTML> Thu, 26 Jul 2012 06:45:42 GMT https://community.qlik.com/t5/QlikView/First-row-in-a-straight-table/m-p/368485#M1172572 sibin_jacob 2012-07-26T06:45:42Z Re: First row in a straight table https://community.qlik.com/t5/QlikView/First-row-in-a-straight-table/m-p/368486#M1172573 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Use Nation and Region as your dimensions too. </P><P></P><P>Then go to Presentation tab in properties and click on Nation and check show partial sum and then repeat the process by clicking of Region. </P><P></P><P> This will give you a pivot table that can be drilled down and will provide you a view you require. </P><P></P><P>Regards </P><P>RL</P></BODY></HTML> Thu, 26 Jul 2012 07:18:35 GMT https://community.qlik.com/t5/QlikView/First-row-in-a-straight-table/m-p/368486#M1172573 2012-07-26T07:18:35Z