Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Simulation using external files

Hello everyone,

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

input field (for example, choose one value from 1 to 10).

How do I build objects (Charts Pivot Tables ...) where the size or expressions depend on the value chosen in the input field?

Instead of having Sum (Field1) I would like to have something like Sum (Field&NumInput) where "NumInput" is the value I

choose in the input field and Field1, Field2, Field3 ... are the values that I have in external files.

Thanks all

0 Replies