topic Re: condition in dimention in QlikView https://community.qlik.com/t5/QlikView/condition-in-dimention/m-p/419082#M1161111 <HTML><HEAD></HEAD><BODY><P>thank you!</P></BODY></HTML> Fri, 09 Nov 2012 07:45:41 GMT 2012-11-09T07:45:41Z condition in dimention https://community.qlik.com/t5/QlikView/condition-in-dimention/m-p/419080#M1161109 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>i have data table with fields: "Country", "Week", "Sale"</P><P></P><P>and i want to create expression like:</P><P></P><P>=sum({&lt;Week={"=2011W01"},Week=&gt;} Sales)</P><P></P><P>in this field i want to get data only in week = 2011W01 Another weeks must be = 0</P><P></P><P>please see attachment</P><P></P><P>if anyone know, pltase help.</P></BODY></HTML> Fri, 09 Nov 2012 07:14:48 GMT https://community.qlik.com/t5/QlikView/condition-in-dimention/m-p/419080#M1161109 2012-11-09T07:14:48Z Re: condition in dimention https://community.qlik.com/t5/QlikView/condition-in-dimention/m-p/419081#M1161110 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> Just remove the "=" sign and the last filter.</P><P></P><P> Your expression should be like this.</P><P></P><P> Sum({&lt;Week = {"20122W01"}&gt;}Sales)</P><P></P><P>Cheers</P><P></P><P>Kaushik Solanki</P></BODY></HTML> Fri, 09 Nov 2012 07:41:10 GMT https://community.qlik.com/t5/QlikView/condition-in-dimention/m-p/419081#M1161110 kaushiknsolanki 2012-11-09T07:41:10Z Re: condition in dimention https://community.qlik.com/t5/QlikView/condition-in-dimention/m-p/419082#M1161111 <HTML><HEAD></HEAD><BODY><P>thank you!</P></BODY></HTML> Fri, 09 Nov 2012 07:45:41 GMT https://community.qlik.com/t5/QlikView/condition-in-dimention/m-p/419082#M1161111 2012-11-09T07:45:41Z