topic How to store expression in Variables in Excel Sheet in QlikView https://community.qlik.com/t5/QlikView/How-to-store-expression-in-Variables-in-Excel-Sheet/m-p/901809#M313659 <HTML><HEAD></HEAD><BODY><P>I am using same expression in many charts, I think it will be more efficeint if I create a variable for each expression and call them from excel sheet. Can anyone help me start on it by advices or pointing to a thread??</P></BODY></HTML> Sat, 18 Jul 2015 18:38:06 GMT Anonymous 2015-07-18T18:38:06Z How to store expression in Variables in Excel Sheet https://community.qlik.com/t5/QlikView/How-to-store-expression-in-Variables-in-Excel-Sheet/m-p/901809#M313659 <HTML><HEAD></HEAD><BODY><P>I am using same expression in many charts, I think it will be more efficeint if I create a variable for each expression and call them from excel sheet. Can anyone help me start on it by advices or pointing to a thread??</P></BODY></HTML> Sat, 18 Jul 2015 18:38:06 GMT https://community.qlik.com/t5/QlikView/How-to-store-expression-in-Variables-in-Excel-Sheet/m-p/901809#M313659 Anonymous 2015-07-18T18:38:06Z Re: How to store expression in Variables in Excel Sheet https://community.qlik.com/t5/QlikView/How-to-store-expression-in-Variables-in-Excel-Sheet/m-p/901810#M313660 <HTML><HEAD></HEAD><BODY><P>there are a lot of post on the same question</P><P></P><P><A href="https://community.qlik.com/message/735857">Re: load variable in qlikview</A></P><P><A href="https://community.qlikview.com/docs/DOC-5012" title="https://community.qlikview.com/docs/DOC-5012">https://community.qlikview.com/docs/DOC-5012</A></P><P><A href="/t5/forums/searchpage/tab/message?q=variable excel">https://community.qlik.com/search.jspa?q=variable+excel</A></P></BODY></HTML> Sat, 18 Jul 2015 18:44:34 GMT https://community.qlik.com/t5/QlikView/How-to-store-expression-in-Variables-in-Excel-Sheet/m-p/901810#M313660 maxgro 2015-07-18T18:44:34Z Re: How to store expression in Variables in Excel Sheet https://community.qlik.com/t5/QlikView/How-to-store-expression-in-Variables-in-Excel-Sheet/m-p/901811#M313661 <HTML><HEAD></HEAD><BODY><P>Take a look at the attached sample. Hopefully this will help.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Sat, 18 Jul 2015 18:50:22 GMT https://community.qlik.com/t5/QlikView/How-to-store-expression-in-Variables-in-Excel-Sheet/m-p/901811#M313661 sunny_talwar 2015-07-18T18:50:22Z Re: How to store expression in Variables in Excel Sheet https://community.qlik.com/t5/QlikView/How-to-store-expression-in-Variables-in-Excel-Sheet/m-p/901812#M313662 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny and Massimo!</P></BODY></HTML> Sat, 18 Jul 2015 18:55:41 GMT https://community.qlik.com/t5/QlikView/How-to-store-expression-in-Variables-in-Excel-Sheet/m-p/901812#M313662 Anonymous 2015-07-18T18:55:41Z Re: How to store expression in Variables in Excel Sheet https://community.qlik.com/t5/QlikView/How-to-store-expression-in-Variables-in-Excel-Sheet/m-p/901813#M313663 <HTML><HEAD></HEAD><BODY><P>Sunny,</P><P></P><P>can you pls explain i=0 and next in your script.</P><P>Many Thanks.</P><P></P><P><IMG alt="imageFile.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/99890_imageFile.png" style="height: auto;" /></P></BODY></HTML> Wed, 23 Sep 2015 23:09:38 GMT https://community.qlik.com/t5/QlikView/How-to-store-expression-in-Variables-in-Excel-Sheet/m-p/901813#M313663 Anonymous 2015-09-23T23:09:38Z Re: How to store expression in Variables in Excel Sheet https://community.qlik.com/t5/QlikView/How-to-store-expression-in-Variables-in-Excel-Sheet/m-p/901814#M313664 <HTML><HEAD></HEAD><BODY><P>'i' is a For loop initiation variable and next is used to increment 'i'. For more details check out this wikipedia link: <A href="https://en.wikipedia.org/wiki/For_loop" title="https://en.wikipedia.org/wiki/For_loop">For loop - Wikipedia, the free encyclopedia</A> </P></BODY></HTML> Thu, 24 Sep 2015 03:10:54 GMT https://community.qlik.com/t5/QlikView/How-to-store-expression-in-Variables-in-Excel-Sheet/m-p/901814#M313664 sunny_talwar 2015-09-24T03:10:54Z