topic Re: Formula question in QlikView https://community.qlik.com/t5/QlikView/Formula-question/m-p/393667#M146778 <HTML><HEAD></HEAD><BODY><P>Use single quotes instead of double quotes.</P></BODY></HTML> Thu, 28 Feb 2013 14:36:15 GMT 2013-02-28T14:36:15Z Formula question https://community.qlik.com/t5/QlikView/Formula-question/m-p/393666#M146777 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have som data called KundeNr</P><P></P><P>601</P><P>602</P><P>603</P><P>etc</P><P></P><P>901</P><P>902</P><P>903</P><P>etc</P><P></P><P>And here I need to add a letter in front of these</P><P></P><P>So S601, S602, S603 etc and F901, F902, F903 etc</P><P></P><P>So now I have KundeNr as Store and then I would like to make If(KundeNr &lt; 800, "S" &amp; KundeNr, "F" &amp; KundeNr) as Store. But it do not work. Probably not the right formula. And that is what I need. So anybody help?</P><P></P><P>best regards</P><P></P><P>Bjarne</P></BODY></HTML> Thu, 28 Feb 2013 14:34:47 GMT https://community.qlik.com/t5/QlikView/Formula-question/m-p/393666#M146777 2013-02-28T14:34:47Z Re: Formula question https://community.qlik.com/t5/QlikView/Formula-question/m-p/393667#M146778 <HTML><HEAD></HEAD><BODY><P>Use single quotes instead of double quotes.</P></BODY></HTML> Thu, 28 Feb 2013 14:36:15 GMT https://community.qlik.com/t5/QlikView/Formula-question/m-p/393667#M146778 2013-02-28T14:36:15Z