topic Dynamically exclude values in set analysis in QlikView https://community.qlik.com/t5/QlikView/Dynamically-exclude-values-in-set-analysis/m-p/1189988#M883799 <HTML><HEAD></HEAD><BODY><P>Hi, I have a line chart that I want to show the 3 lines:</P><P>1. a team total</P><P>2. figure of one person</P><P>3. combined figure of all other people in the same team except the selected person</P><P></P><P>I managed to do the first 2, but couldn't figure out how to do #3 as the selection will change so I cannot hard code the values in the set analysis expression.</P><P></P><P>qvw is attached. Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Dynamically exclude values in set analysis https://community.qlik.com/t5/QlikView/Dynamically-exclude-values-in-set-analysis/m-p/1189988#M883799 <HTML><HEAD></HEAD><BODY><P>Hi, I have a line chart that I want to show the 3 lines:</P><P>1. a team total</P><P>2. figure of one person</P><P>3. combined figure of all other people in the same team except the selected person</P><P></P><P>I managed to do the first 2, but couldn't figure out how to do #3 as the selection will change so I cannot hard code the values in the set analysis expression.</P><P></P><P>qvw is attached. Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Dynamically-exclude-values-in-set-analysis/m-p/1189988#M883799 2020-11-25T16:16:04Z Re: Dynamically exclude values in set analysis https://community.qlik.com/t5/QlikView/Dynamically-exclude-values-in-set-analysis/m-p/1189989#M883800 <HTML><HEAD></HEAD><BODY><P>Try Sum({$&lt;Year=, Person=E(Person)&gt;} Hours) / Count(DISTINCT {$&lt;Year=, Person=E(Person)&gt;} Project)</P></BODY></HTML> Fri, 23 Sep 2016 07:14:06 GMT https://community.qlik.com/t5/QlikView/Dynamically-exclude-values-in-set-analysis/m-p/1189989#M883800 Gysbert_Wassenaar 2016-09-23T07:14:06Z Re: Dynamically exclude values in set analysis https://community.qlik.com/t5/QlikView/Dynamically-exclude-values-in-set-analysis/m-p/1189990#M883801 <HTML><HEAD></HEAD><BODY><P>Thanks so much! Exactly what I was hoping to do!</P></BODY></HTML> Sat, 24 Sep 2016 13:33:10 GMT https://community.qlik.com/t5/QlikView/Dynamically-exclude-values-in-set-analysis/m-p/1189990#M883801 2016-09-24T13:33:10Z