topic Re: Trouble with If Statement in QlikView https://community.qlik.com/t5/QlikView/Trouble-with-If-Statement/m-p/379967#M491588 <HTML><HEAD></HEAD><BODY><P>Remove "=" sign</P><P></P><P>if ([UkDivisionCat19] = 'ACE'<BR />,</P><P>&nbsp; <SPAN style="font-size: 8pt;"><BR />(</SPAN><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">$(vCostpertonne)</EM></STRONG></EM></STRONG></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P></P><P>/</P><P></P><P><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">$(vAvgeTravelMiles)</EM></STRONG></EM></STRONG></P><P><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">)</EM></STRONG></EM></STRONG></P><P></P><P><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG></STRONG></EM></STRONG></P></BODY></HTML> Wed, 22 Aug 2012 16:25:27 GMT bgerchikov 2012-08-22T16:25:27Z Trouble with If Statement https://community.qlik.com/t5/QlikView/Trouble-with-If-Statement/m-p/379965#M491586 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I'm trying to combine an If Statement with variables i have created . It doesn't work - wonderd if i am attempting the impossible.</P><P></P><P><SPAN style="color: #008000; font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="color: #008000; font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="color: #008000; font-size: 8pt;"></SPAN></P><P>if ([UkDivisionCat19] = 'ACE'<BR />,</P><P></P><P></P><P><SPAN style="font-size: 8pt;"><BR />(</SPAN><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">$(=vCostpertonne)</EM></STRONG></EM></STRONG></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>/</P><P></P><P><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">$(=vAvgeTravelMiles)</EM></STRONG></EM></STRONG></P><P><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">)</EM></STRONG></EM></STRONG></P><P><STRONG></STRONG></P><P><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">Any suggestions appreciated - thanks</EM></STRONG></EM></STRONG></P><P></P></BODY></HTML> Wed, 22 Aug 2012 15:16:40 GMT https://community.qlik.com/t5/QlikView/Trouble-with-If-Statement/m-p/379965#M491586 timsaddler 2012-08-22T15:16:40Z Re: Trouble with If Statement https://community.qlik.com/t5/QlikView/Trouble-with-If-Statement/m-p/379966#M491587 <HTML><HEAD></HEAD><BODY><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;"><SPAN style="font-size: 8pt; color: #008000;"> use this </SPAN></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;"></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">if ([UkDivisionCat19] = 'ACE'<BR />,</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;"><SPAN style="font-size: 8pt;"><BR />(</SPAN><STRONG><EM style="font-size: 8pt; color: #808080;">vCostpertonne</EM></STRONG></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;"><SPAN style="font-size: 8pt;"> </SPAN></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;"></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">/</P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;"><STRONG><EM style="font-size: 8pt; color: #808080;">vAvgeTravelMiles</EM></STRONG></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;"><STRONG><EM style="font-size: 8pt; color: #808080;">)</EM></STRONG></P></BODY></HTML> Wed, 22 Aug 2012 15:21:42 GMT https://community.qlik.com/t5/QlikView/Trouble-with-If-Statement/m-p/379966#M491587 SunilChauhan 2012-08-22T15:21:42Z Re: Trouble with If Statement https://community.qlik.com/t5/QlikView/Trouble-with-If-Statement/m-p/379967#M491588 <HTML><HEAD></HEAD><BODY><P>Remove "=" sign</P><P></P><P>if ([UkDivisionCat19] = 'ACE'<BR />,</P><P>&nbsp; <SPAN style="font-size: 8pt;"><BR />(</SPAN><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">$(vCostpertonne)</EM></STRONG></EM></STRONG></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P></P><P>/</P><P></P><P><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">$(vAvgeTravelMiles)</EM></STRONG></EM></STRONG></P><P><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">)</EM></STRONG></EM></STRONG></P><P></P><P><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG></STRONG></EM></STRONG></P></BODY></HTML> Wed, 22 Aug 2012 16:25:27 GMT https://community.qlik.com/t5/QlikView/Trouble-with-If-Statement/m-p/379967#M491588 bgerchikov 2012-08-22T16:25:27Z