I have several where statements in my QV dashboard and they keep on changing which means change in script. In my current organization if the dashboard is implemented in server we are not allowed to do so frequent changes in the script. Is there any way I can use include option to write where condition. Attached is a sample data, say I want to filter the data only for United States.
I am aware of using entire script through Include option, however I am looking to pass only where clause through Include option.
If I'm understanding what you are trying to do, you want to have the 'QVW' load the script, and you (Load Script.txt). You can then manually update Load Script.txt to update the where clause, so you don't have to update the QVW every time?
If this is the case, in your script, you only need:
$(Include=C:\Users\deys\Desktop\Data Validation\Qlikview Include Option\Load Script.txt);
In the document you are adding, you have the load script before the include. This will bring in United States, and whatever the include has due to concatenation. Remove the first load statement, and make your script be just this:
$(Include=C:\Users\deys\Desktop\Data Validation\Qlikview Include Option\Load Script.txt)
; Run a reload, using the Load Script.txt that you attached. You should only get 'United States' records. Next, update the text file (make sure to update the one this is pointing to on your desktop) and change the Where to be only 'Belgium' and you should only get Belgium records.