topic Re: Set Analysis - Total with a specific condition in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070379#M357581 <HTML><HEAD></HEAD><BODY><P>It will ignore all the selection of Date Field only as you are bypasing it in Set analysis<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 12 Jan 2016 12:15:33 GMT Anonymous 2016-01-12T12:15:33Z Set Analysis - Total with a specific condition https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070372#M357574 <HTML><HEAD></HEAD><BODY><P>Hi people, </P><P></P><P>How Can use the Total keyword using&nbsp; to calculate a expression in chart but to a specific player? Like that:</P><P></P><P>=SUM( {&lt;Total&gt; DATE, PLAYER = 1234} Nr_Goals)</P><P></P><P>Thanks!!!</P></BODY></HTML> Tue, 12 Jan 2016 10:31:48 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070372#M357574 2016-01-12T10:31:48Z Re: Set Analysis - Total with a specific condition https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070373#M357575 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Sum(TOTAL {&lt;PLAYER = {1234}&gt;} Nr_Goals)</STRONG></P></BODY></HTML> Tue, 12 Jan 2016 10:41:58 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070373#M357575 sunny_talwar 2016-01-12T10:41:58Z Re: Set Analysis - Total with a specific condition https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070374#M357576 <HTML><HEAD></HEAD><BODY><P>With that I guarantee that I ignore all selections, right?</P></BODY></HTML> Tue, 12 Jan 2016 10:49:22 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070374#M357576 2016-01-12T10:49:22Z Re: Set Analysis - Total with a specific condition https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070375#M357577 <HTML><HEAD></HEAD><BODY><P>may be this as well?</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=Sum(TOTAL &lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">DATE</SPAN>&gt; {&lt;PLAYER = {1234}&gt;} Nr_Goals)</STRONG></P></BODY></HTML> Tue, 12 Jan 2016 10:49:22 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070375#M357577 Anonymous 2016-01-12T10:49:22Z Re: Set Analysis - Total with a specific condition https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070376#M357578 <HTML><HEAD></HEAD><BODY><P>may be this</P><P></P><P><STRONG>=sum(Total{DATE=,PLAYER={1234}},Nr_Goals)</STRONG></P></BODY></HTML> Tue, 12 Jan 2016 10:59:21 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070376#M357578 ahmar811 2016-01-12T10:59:21Z Re: Set Analysis - Total with a specific condition https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070377#M357579 <HTML><HEAD></HEAD><BODY><P>You forgot to add &lt;&gt; signs:</P><P></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>=Sum(Total{<SPAN style="color: #ff0000;">&lt;</SPAN>DATE=,PLAYER={1234}<SPAN style="color: #ff0000;">&gt;</SPAN>} Nr_Goals)</STRONG></SPAN></P></BODY></HTML> Tue, 12 Jan 2016 11:04:28 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070377#M357579 sunny_talwar 2016-01-12T11:04:28Z Re: Set Analysis - Total with a specific condition https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070378#M357580 <HTML><HEAD></HEAD><BODY><P>sorry my mistake</P><P><STRONG>=sum(Total{&lt;DATE=,PLAYER={1234}&gt;},Nr_Goals)</STRONG></P><P><BR /> </P></BODY></HTML> Tue, 12 Jan 2016 11:10:07 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070378#M357580 ahmar811 2016-01-12T11:10:07Z Re: Set Analysis - Total with a specific condition https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070379#M357581 <HTML><HEAD></HEAD><BODY><P>It will ignore all the selection of Date Field only as you are bypasing it in Set analysis<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 12 Jan 2016 12:15:33 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Total-with-a-specific-condition/m-p/1070379#M357581 Anonymous 2016-01-12T12:15:33Z