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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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