topic Multiple Value in if Statement in QlikView https://community.qlik.com/t5/QlikView/Multiple-Value-in-if-Statement/m-p/710563#M1077746 <HTML><HEAD></HEAD><BODY><P>QLikViewReport Filter We Use Week (Week-1,Week-2,Week-3,Week-4) When Select Week-1 Then Sum(Quantity*25/100)as so onIts Warking ,</P><P>But We Want To Select (Week-1 &amp; Week-2 ) Then Sum(Quantity*50/100) How is Possible.</P></BODY></HTML> Sat, 19 Jul 2014 09:28:18 GMT vijayit43 2014-07-19T09:28:18Z Multiple Value in if Statement https://community.qlik.com/t5/QlikView/Multiple-Value-in-if-Statement/m-p/710563#M1077746 <HTML><HEAD></HEAD><BODY><P>QLikViewReport Filter We Use Week (Week-1,Week-2,Week-3,Week-4) When Select Week-1 Then Sum(Quantity*25/100)as so onIts Warking ,</P><P>But We Want To Select (Week-1 &amp; Week-2 ) Then Sum(Quantity*50/100) How is Possible.</P></BODY></HTML> Sat, 19 Jul 2014 09:28:18 GMT https://community.qlik.com/t5/QlikView/Multiple-Value-in-if-Statement/m-p/710563#M1077746 vijayit43 2014-07-19T09:28:18Z Re: Multiple Value in if Statement https://community.qlik.com/t5/QlikView/Multiple-Value-in-if-Statement/m-p/710564#M1077747 <HTML><HEAD></HEAD><BODY><P>Provide Sample data...</P></BODY></HTML> Sat, 19 Jul 2014 13:38:30 GMT https://community.qlik.com/t5/QlikView/Multiple-Value-in-if-Statement/m-p/710564#M1077747 MK_QSL 2014-07-19T13:38:30Z Re: Multiple Value in if Statement https://community.qlik.com/t5/QlikView/Multiple-Value-in-if-Statement/m-p/710565#M1077749 <HTML><HEAD></HEAD><BODY><P>try GetSlectedCount function to see how many values are selected in the week field, than try like below</P><P>=if(getselectedcount(yourfieldname==2), <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sum(Quantity*50/100)</SPAN>, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sum(Quantity*25/100))</SPAN></P></BODY></HTML> Sat, 19 Jul 2014 23:12:34 GMT https://community.qlik.com/t5/QlikView/Multiple-Value-in-if-Statement/m-p/710565#M1077749 israrkhan 2014-07-19T23:12:34Z Re: Multiple Value in if Statement https://community.qlik.com/t5/QlikView/Multiple-Value-in-if-Statement/m-p/710566#M1077750 <HTML><HEAD></HEAD><BODY><P>sum(Quantity*(25*$(=getselectedcount(Week)))/100)</P></BODY></HTML> Sun, 20 Jul 2014 03:19:19 GMT https://community.qlik.com/t5/QlikView/Multiple-Value-in-if-Statement/m-p/710566#M1077750 preminqlik 2014-07-20T03:19:19Z