topic Two charts on same sheet with different selections of same field in QlikView https://community.qlik.com/t5/QlikView/Two-charts-on-same-sheet-with-different-selections-of-same-field/m-p/199178#M58217 <HTML><HEAD></HEAD><BODY><P>see in my example</P></BODY></HTML> Wed, 23 Jun 2010 12:50:20 GMT sparur 2010-06-23T12:50:20Z Two charts on same sheet with different selections of same field https://community.qlik.com/t5/QlikView/Two-charts-on-same-sheet-with-different-selections-of-same-field/m-p/199175#M58214 <HTML><HEAD></HEAD><BODY><P>I have a field called "Narative" and want to display two straight table charts on one sheet. One with Narrative value like 'SETTLEMENT*' and othe other the other with all other values</P></BODY></HTML> Wed, 23 Jun 2010 12:17:50 GMT https://community.qlik.com/t5/QlikView/Two-charts-on-same-sheet-with-different-selections-of-same-field/m-p/199175#M58214 Anonymous 2010-06-23T12:17:50Z Two charts on same sheet with different selections of same field https://community.qlik.com/t5/QlikView/Two-charts-on-same-sheet-with-different-selections-of-same-field/m-p/199176#M58215 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>that´s a case to use SET Analysis.</P><P>Expression a): Sum({$}Amount) //calculate the amount regarding your selection</P><P>Expression b): Sum({1-$}Amount) //calculate all other values but not the selected ones</P><P>See also QV help for more details.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Wed, 23 Jun 2010 12:44:16 GMT https://community.qlik.com/t5/QlikView/Two-charts-on-same-sheet-with-different-selections-of-same-field/m-p/199176#M58215 2010-06-23T12:44:16Z Two charts on same sheet with different selections of same field https://community.qlik.com/t5/QlikView/Two-charts-on-same-sheet-with-different-selections-of-same-field/m-p/199177#M58216 <HTML><HEAD></HEAD><BODY><P>Use the set analysis function: (in the following I assume that you need to express sum of amounts, adjust the expressions according to your needs)</P><P>Expression in chart #1:<BR />sum( { $ &lt; Narrative = {"SETTLEMENT*"} &gt; } Amount )</P><P>Expression in chart #2:<BR />sum( Amount )</P><P>regards</P></BODY></HTML> Wed, 23 Jun 2010 12:44:18 GMT https://community.qlik.com/t5/QlikView/Two-charts-on-same-sheet-with-different-selections-of-same-field/m-p/199177#M58216 2010-06-23T12:44:18Z Two charts on same sheet with different selections of same field https://community.qlik.com/t5/QlikView/Two-charts-on-same-sheet-with-different-selections-of-same-field/m-p/199178#M58217 <HTML><HEAD></HEAD><BODY><P>see in my example</P></BODY></HTML> Wed, 23 Jun 2010 12:50:20 GMT https://community.qlik.com/t5/QlikView/Two-charts-on-same-sheet-with-different-selections-of-same-field/m-p/199178#M58217 sparur 2010-06-23T12:50:20Z Two charts on same sheet with different selections of same field https://community.qlik.com/t5/QlikView/Two-charts-on-same-sheet-with-different-selections-of-same-field/m-p/199179#M58218 <HTML><HEAD></HEAD><BODY><P>Problem solved - Thanks</P></BODY></HTML> Wed, 23 Jun 2010 13:13:55 GMT https://community.qlik.com/t5/QlikView/Two-charts-on-same-sheet-with-different-selections-of-same-field/m-p/199179#M58218 Anonymous 2010-06-23T13:13:55Z