topic Re: Where Clausule in expression in QlikView https://community.qlik.com/t5/QlikView/Where-Clausule-in-expression/m-p/409853#M152434 <HTML><HEAD></HEAD><BODY><P>Doesn't work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Wed, 05 Dec 2012 14:17:00 GMT 2012-12-05T14:17:00Z Where Clausule in expression https://community.qlik.com/t5/QlikView/Where-Clausule-in-expression/m-p/409851#M152432 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I want to make a pivot table with dimension MonthYear, with 13 expressions. </P><P></P><P>4 of the 13 expressions are all for Revenue, sorted in Booking, Prospect, Unlabeled and Extension.</P><P></P><P>I want an expression like: </P><P></P><P>sum(Revenue) where Stage = 'Booking'</P><P>sum(Revenue) where Stage = 'Prospect'</P><P>etc.</P><P></P><P>How can i do this in Qlikview expressions?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 05 Dec 2012 14:12:48 GMT https://community.qlik.com/t5/QlikView/Where-Clausule-in-expression/m-p/409851#M152432 2012-12-05T14:12:48Z Re: Where Clausule in expression https://community.qlik.com/t5/QlikView/Where-Clausule-in-expression/m-p/409852#M152433 <HTML><HEAD></HEAD><BODY><P>try: </P><P>sum({&lt;Stage={'Booking'}&gt;}Revenue)</P><P>sum({&lt;Stage={'Prospect'}&gt;}Revenue)</P><P>etc.</P></BODY></HTML> Wed, 05 Dec 2012 14:15:13 GMT https://community.qlik.com/t5/QlikView/Where-Clausule-in-expression/m-p/409852#M152433 Gysbert_Wassenaar 2012-12-05T14:15:13Z Re: Where Clausule in expression https://community.qlik.com/t5/QlikView/Where-Clausule-in-expression/m-p/409853#M152434 <HTML><HEAD></HEAD><BODY><P>Doesn't work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Wed, 05 Dec 2012 14:17:00 GMT https://community.qlik.com/t5/QlikView/Where-Clausule-in-expression/m-p/409853#M152434 2012-12-05T14:17:00Z Re: Where Clausule in expression https://community.qlik.com/t5/QlikView/Where-Clausule-in-expression/m-p/409854#M152435 <HTML><HEAD></HEAD><BODY><P>Excuse me, it does work, can't calculate in the sum... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /> thanks</P></BODY></HTML> Wed, 05 Dec 2012 14:21:34 GMT https://community.qlik.com/t5/QlikView/Where-Clausule-in-expression/m-p/409854#M152435 2012-12-05T14:21:34Z