This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
QlikView documentation and resources.
I've been reading a lot of discussions about loading expression from external files and most of them suggest on creating variable in the load script using peek. Here are my thoughts
Downside of creating variables in the Script:
Attached is Sample that lets you evaluate your expressions Loaded from an excel file directly in your chart.
The Trick is simple, make your string evaluate as a Variable using the Dollar Expansion in the chart
The use of Aggr() seems unnecessary. I would suggest using Only() instead, to make the expansion more efficient.
Yep, totally forgot about that Thanks @Toni
incorporated ONLY() as suggested
Excellent approach, will give it a try!!
Thanks for sharing!
Looks great, will have to deep dive to see what its doing. Thanks for sharing
Great!! Very Helpful
I don't think there is anything wrong with what you are doing. However, I think the downsides you listed for the variable approach are incorrect. Perhaps you are not familiar with the script loop to load variables from a file? The exact same spreadsheet you provided for your sample can be used to load variables as well. Variables are loaded in a loop, and no script changes are necessary when variables are added or removed.
Storing variables outside of QlikView - The Qlik Fix! The Qlik Fix!
I had not come across this.
Nice article !!!. Thanks for sharing
I agree with Rob.
-->Creating variables in the script, does not influence how many variables you have to create.
--> A loop fixes this.
--> Not if you use a loop.
I wonder what the performance of this method is compared to actually creating variables with expressions.
Do you have an example app where you compare the 2 methods?
Reading variables from an external file and creating them in the script can be easily done with the qvc.populatevariables subroutine of the Qlikview Component Library.