topic Re: Pivot table chart displaying data for two different source types in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-chart-displaying-data-for-two-different-source-types/m-p/571136#M1098748 <HTML><HEAD></HEAD><BODY><P>I figured this out.&nbsp; Thanks!</P></BODY></HTML> Tue, 29 Apr 2014 18:34:42 GMT 2014-04-29T18:34:42Z Pivot table chart displaying data for two different source types https://community.qlik.com/t5/QlikView/Pivot-table-chart-displaying-data-for-two-different-source-types/m-p/571134#M1098746 <HTML><HEAD></HEAD><BODY><P>I am trying 2 pivot table charts for 2 different sources of trasactions.&nbsp; The data all comes from one SQL statement.&nbsp; Basically one would be source = GL (General Ledger) and the other source = PA (Project Accounting).&nbsp; However, when I filter on one source both pivot tables reflect those values.&nbsp; I can't get them to show GL and PA.&nbsp; I remember set analysis from my training.&nbsp; Would this be a case where'd I'd use that?&nbsp; I just want to hard code the source type for each.&nbsp; The expression used is very straight forward Sum(Amount), so I want the Sum(Amount) for GL and Sum(Amount) for PA.&nbsp; Thanks!</P></BODY></HTML> Tue, 29 Apr 2014 00:17:35 GMT https://community.qlik.com/t5/QlikView/Pivot-table-chart-displaying-data-for-two-different-source-types/m-p/571134#M1098746 2014-04-29T00:17:35Z Re: Pivot table chart displaying data for two different source types https://community.qlik.com/t5/QlikView/Pivot-table-chart-displaying-data-for-two-different-source-types/m-p/571135#M1098747 <HTML><HEAD></HEAD><BODY><P>Could you post your Data Model? (Control -T), it´s easier to help, knowing more about your data</P></BODY></HTML> Tue, 29 Apr 2014 00:28:44 GMT https://community.qlik.com/t5/QlikView/Pivot-table-chart-displaying-data-for-two-different-source-types/m-p/571135#M1098747 Clever_Anjos 2014-04-29T00:28:44Z Re: Pivot table chart displaying data for two different source types https://community.qlik.com/t5/QlikView/Pivot-table-chart-displaying-data-for-two-different-source-types/m-p/571136#M1098748 <HTML><HEAD></HEAD><BODY><P>I figured this out.&nbsp; Thanks!</P></BODY></HTML> Tue, 29 Apr 2014 18:34:42 GMT https://community.qlik.com/t5/QlikView/Pivot-table-chart-displaying-data-for-two-different-source-types/m-p/571136#M1098748 2014-04-29T18:34:42Z