topic Re: Dollar $ Expansion Expression and Division in QlikView https://community.qlik.com/t5/QlikView/Dollar-Expansion-Expression-and-Division/m-p/490517#M1134347 <HTML><HEAD></HEAD><BODY><P>If you load the expressions from excel they're just text values. You can't expand those to get a different expression for each row. If you want that kind of thing you'll have to create a variable that contains pick-match expression. See this discussion: <A href="https://community.qlik.com/thread/67420">Expressions in Fields</A></P></BODY></HTML> Fri, 18 Oct 2013 14:39:36 GMT Gysbert_Wassenaar 2013-10-18T14:39:36Z Dollar $ Expansion Expression and Division https://community.qlik.com/t5/QlikView/Dollar-Expansion-Expression-and-Division/m-p/490511#M1134341 <HTML><HEAD></HEAD><BODY><P>During my load script I'm loading in numerous expressions from a master file (currently in an Excel workbook).&nbsp;&nbsp; I've also created an inline table, RoundTo, to let the user apply rounding. The values are 1, 1000, and 1000000.</P><P></P><P>When I add my expression I'm setting the definition as =$(e_My_Expression) and it works just as expected.&nbsp; However, when I try to apply my rounding using =$(e_My_Expression)/RoundTo the division is completely ignored.</P><P></P><P>Any suggestions? </P><P></P><P>Thanks in advance,</P><P></P><P>Mark</P></BODY></HTML> Fri, 18 Oct 2013 11:54:11 GMT https://community.qlik.com/t5/QlikView/Dollar-Expansion-Expression-and-Division/m-p/490511#M1134341 2013-10-18T11:54:11Z Re: Dollar $ Expansion Expression and Division https://community.qlik.com/t5/QlikView/Dollar-Expansion-Expression-and-Division/m-p/490512#M1134342 <HTML><HEAD></HEAD><BODY><P>Could you share your sample app?</P></BODY></HTML> Fri, 18 Oct 2013 12:06:45 GMT https://community.qlik.com/t5/QlikView/Dollar-Expansion-Expression-and-Division/m-p/490512#M1134342 tresB 2013-10-18T12:06:45Z Re: Dollar $ Expansion Expression and Division https://community.qlik.com/t5/QlikView/Dollar-Expansion-Expression-and-Division/m-p/490513#M1134343 <HTML><HEAD></HEAD><BODY><P>I guess the problem is that RoundTo field is having 3 values.</P><P>so, when you are dividing ur expression with 'RoundTo' field then its not taking any of the value.</P><P>You need to select atleast one value of RoundTo field all the time so that it takes one value and divide it with your expression.</P><P></P><P></P><P>Regards</P><P>Erika</P></BODY></HTML> Fri, 18 Oct 2013 13:09:21 GMT https://community.qlik.com/t5/QlikView/Dollar-Expansion-Expression-and-Division/m-p/490513#M1134343 Anonymous 2013-10-18T13:09:21Z Re: Dollar $ Expansion Expression and Division https://community.qlik.com/t5/QlikView/Dollar-Expansion-Expression-and-Division/m-p/490514#M1134344 <HTML><HEAD></HEAD><BODY><P><BR />Hi Erika - I do have the restriction applied, so that doesn't seem to be the issue.&nbsp; The app has a list box with 1, 1000, and 1000000 with "always one selected value" enabled.</P></BODY></HTML> Fri, 18 Oct 2013 13:13:52 GMT https://community.qlik.com/t5/QlikView/Dollar-Expansion-Expression-and-Division/m-p/490514#M1134344 2013-10-18T13:13:52Z Re: Re: Dollar $ Expansion Expression and Division https://community.qlik.com/t5/QlikView/Dollar-Expansion-Expression-and-Division/m-p/490515#M1134345 <HTML><HEAD></HEAD><BODY><P>Have a look at the attached sample. Hope this helps.</P></BODY></HTML> Fri, 18 Oct 2013 13:22:39 GMT https://community.qlik.com/t5/QlikView/Dollar-Expansion-Expression-and-Division/m-p/490515#M1134345 tresB 2013-10-18T13:22:39Z Re: Dollar $ Expansion Expression and Division https://community.qlik.com/t5/QlikView/Dollar-Expansion-Expression-and-Division/m-p/490516#M1134346 <HTML><HEAD></HEAD><BODY><P>For some odd reason it works if I put the expression in an Inline load (like you did), but if I load in from Excel is does not work.</P></BODY></HTML> Fri, 18 Oct 2013 13:56:51 GMT https://community.qlik.com/t5/QlikView/Dollar-Expansion-Expression-and-Division/m-p/490516#M1134346 2013-10-18T13:56:51Z Re: Dollar $ Expansion Expression and Division https://community.qlik.com/t5/QlikView/Dollar-Expansion-Expression-and-Division/m-p/490517#M1134347 <HTML><HEAD></HEAD><BODY><P>If you load the expressions from excel they're just text values. You can't expand those to get a different expression for each row. If you want that kind of thing you'll have to create a variable that contains pick-match expression. See this discussion: <A href="https://community.qlik.com/thread/67420">Expressions in Fields</A></P></BODY></HTML> Fri, 18 Oct 2013 14:39:36 GMT https://community.qlik.com/t5/QlikView/Dollar-Expansion-Expression-and-Division/m-p/490517#M1134347 Gysbert_Wassenaar 2013-10-18T14:39:36Z