topic Deduction Counts in QlikView https://community.qlik.com/t5/QlikView/Deduction-Counts/m-p/698993#M1070768 <HTML><HEAD></HEAD><BODY><P><IMG alt="Screenshot.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/64667_Screenshot.png" style="width: 620px; height: 388px;" /></P><P>I am looking to recreate this spreadsheet that I made in Excel using a data connection and a series of pivot tables. Any ideas on how to get me started creating this in QlikView will be greatly appreciated. </P></BODY></HTML> Mon, 18 Aug 2014 18:20:59 GMT Anonymous 2014-08-18T18:20:59Z Deduction Counts https://community.qlik.com/t5/QlikView/Deduction-Counts/m-p/698993#M1070768 <HTML><HEAD></HEAD><BODY><P><IMG alt="Screenshot.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/64667_Screenshot.png" style="width: 620px; height: 388px;" /></P><P>I am looking to recreate this spreadsheet that I made in Excel using a data connection and a series of pivot tables. Any ideas on how to get me started creating this in QlikView will be greatly appreciated. </P></BODY></HTML> Mon, 18 Aug 2014 18:20:59 GMT https://community.qlik.com/t5/QlikView/Deduction-Counts/m-p/698993#M1070768 Anonymous 2014-08-18T18:20:59Z Re: Deduction Counts https://community.qlik.com/t5/QlikView/Deduction-Counts/m-p/698994#M1070769 <HTML><HEAD></HEAD><BODY><P>You can try loading the row headers&nbsp; as a dimension so that the data in Qlik is like:</P><P></P><P>Location, Metric, Metric Value, Insurance Type</P><P>NC,Single 1, 135, Health</P><P>NC, Single 2, 181, Health</P><P></P><P>etc....</P><P></P><P>Then create a pivot table with&nbsp; Location and Metric as the dimensions.</P><P></P><P>The expression would then leverage the [Metric Value] field with some IF statements&nbsp; to pick up the different number formatting and aggregations.</P><P></P><P>Use 3 different charts for the insurance types and SET ANALYSIS to focus each chart to a specific insurance type. </P><P></P><P>If you have more than 3 insurance types and need that to be dynamic it will be more complicated.</P></BODY></HTML> Mon, 18 Aug 2014 18:35:30 GMT https://community.qlik.com/t5/QlikView/Deduction-Counts/m-p/698994#M1070769 JonnyPoole 2014-08-18T18:35:30Z