topic Re: expression in QlikView https://community.qlik.com/t5/QlikView/expression/m-p/589327#M1098488 <HTML><HEAD></HEAD><BODY><P>TRY</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sum ({&lt; Year = {$(=(max(Year)))}, DivisionName ={'Van XXX','XXX'} , </SPAN><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Production.VehicleCategory -={'Scan'}&gt;} </STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">CharterKilometers)/1000</SPAN></P></BODY></HTML> Thu, 17 Apr 2014 08:50:47 GMT rustyfishbones 2014-04-17T08:50:47Z expression https://community.qlik.com/t5/QlikView/expression/m-p/589325#M1098486 <HTML><HEAD></HEAD><BODY><P>HI all,</P><P></P><P>This is my expression:</P><P>Sum ({&lt; Year = {$(=(max(Year)))}, DivisionName ={'Van XXX','XXX'}&gt;} , <STRONG>Production.VehicleCategory &lt;&gt;&nbsp; 'Scan'</STRONG> CharterKilometers)/1000</P><P></P><P>How can I let qlikview exclude on that vehiclecategory?</P><P></P><P>kind regards</P></BODY></HTML> Thu, 17 Apr 2014 08:45:08 GMT https://community.qlik.com/t5/QlikView/expression/m-p/589325#M1098486 2014-04-17T08:45:08Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/589326#M1098487 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sum ({&lt; Year = {$(=(max(Year)))}, DivisionName ={'Van XXX','XXX'} , </SPAN><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">VehicleCategory ={'*'}-{'Scan'}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">&gt;}</SPAN></STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> CharterKilometers)/1000</SPAN></P></BODY></HTML> Thu, 17 Apr 2014 08:48:44 GMT https://community.qlik.com/t5/QlikView/expression/m-p/589326#M1098487 alexandros17 2014-04-17T08:48:44Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/589327#M1098488 <HTML><HEAD></HEAD><BODY><P>TRY</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sum ({&lt; Year = {$(=(max(Year)))}, DivisionName ={'Van XXX','XXX'} , </SPAN><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Production.VehicleCategory -={'Scan'}&gt;} </STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">CharterKilometers)/1000</SPAN></P></BODY></HTML> Thu, 17 Apr 2014 08:50:47 GMT https://community.qlik.com/t5/QlikView/expression/m-p/589327#M1098488 rustyfishbones 2014-04-17T08:50:47Z