topic Simulation using external files in QlikView https://community.qlik.com/t5/QlikView/Simulation-using-external-files/m-p/246875#M94077 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P>My problem is to make a simulation choosing whenever an external Excel file reference. The choice of the file I can do it with an </P><P></P><P>input field (for example, choose one value from 1 to 10).</P><P>How do I build objects (Charts Pivot Tables ...) where the size or expressions depend on the value chosen in the input field?</P><P>Instead of having Sum (Field1) I would like to have something like Sum (Field&amp;NumInput) where "NumInput" is the value I </P><P></P><P>choose in the input field and Field1, Field2, Field3 ... are the values that I have in external files.</P><P></P><P>Thanks all</P></BODY></HTML> Thu, 13 Oct 2011 15:15:36 GMT 2011-10-13T15:15:36Z Simulation using external files https://community.qlik.com/t5/QlikView/Simulation-using-external-files/m-p/246875#M94077 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P>My problem is to make a simulation choosing whenever an external Excel file reference. The choice of the file I can do it with an </P><P></P><P>input field (for example, choose one value from 1 to 10).</P><P>How do I build objects (Charts Pivot Tables ...) where the size or expressions depend on the value chosen in the input field?</P><P>Instead of having Sum (Field1) I would like to have something like Sum (Field&amp;NumInput) where "NumInput" is the value I </P><P></P><P>choose in the input field and Field1, Field2, Field3 ... are the values that I have in external files.</P><P></P><P>Thanks all</P></BODY></HTML> Thu, 13 Oct 2011 15:15:36 GMT https://community.qlik.com/t5/QlikView/Simulation-using-external-files/m-p/246875#M94077 2011-10-13T15:15:36Z