topic Pivot Table report in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-report/m-p/263767#M1189057 <HTML><HEAD></HEAD><BODY><P>Hi All!</P><P></P><P>I need some Help..</P><P></P><P>I have attched a sample Excel file.</P><P></P><P></P><P>What I need is ...</P><P>I want to display Policy No. whose Gross Claims is greater than 50 Lacs.</P><P></P><P>I need a Pivot table in which Policy No. is being shown as Dimension and Expression is Gross Claims Gretaer than 50 lacs.</P><P></P><P>When I expand the table The second Dimension is Claims Nos. ,</P><P>when Pivot is Expandted upto Claim level then the Amount should be distributed Accordingly.</P><P></P><P></P><P>Plz help...:(</P></BODY></HTML> Thu, 15 Sep 2011 06:55:06 GMT 2011-09-15T06:55:06Z Pivot Table report https://community.qlik.com/t5/QlikView/Pivot-Table-report/m-p/263767#M1189057 <HTML><HEAD></HEAD><BODY><P>Hi All!</P><P></P><P>I need some Help..</P><P></P><P>I have attched a sample Excel file.</P><P></P><P></P><P>What I need is ...</P><P>I want to display Policy No. whose Gross Claims is greater than 50 Lacs.</P><P></P><P>I need a Pivot table in which Policy No. is being shown as Dimension and Expression is Gross Claims Gretaer than 50 lacs.</P><P></P><P>When I expand the table The second Dimension is Claims Nos. ,</P><P>when Pivot is Expandted upto Claim level then the Amount should be distributed Accordingly.</P><P></P><P></P><P>Plz help...:(</P></BODY></HTML> Thu, 15 Sep 2011 06:55:06 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-report/m-p/263767#M1189057 2011-09-15T06:55:06Z Re: Pivot Table report https://community.qlik.com/t5/QlikView/Pivot-Table-report/m-p/263768#M1189058 <HTML><HEAD></HEAD><BODY><P>please see the attached file </P><P></P><P>hope this helps</P></BODY></HTML> Thu, 15 Sep 2011 08:17:45 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-report/m-p/263768#M1189058 SunilChauhan 2011-09-15T08:17:45Z Pivot Table report https://community.qlik.com/t5/QlikView/Pivot-Table-report/m-p/263769#M1189059 <HTML><HEAD></HEAD><BODY><P> Hi Sunil!</P><P></P><P>Thanks for all ur help.</P><P></P><P>But actualy I think I was not able to explain my problem properly.</P><P></P><P>But I Have got the solution.</P><P></P><P></P><P>Thnks once again.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 15 Sep 2011 09:58:21 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-report/m-p/263769#M1189059 2011-09-15T09:58:21Z