Add Variable to Load Script

[#1]

Hi,

I am trying to load data using a variable. Basically I want to change my Where statement into a variable on load. The value for the variable will be manually input into an input box on the qlikview report.

Currently my where statement reads as follows

where

[Customer_Number] = '7527301'

;

I have created the variable 'vCustomer' but am now lost on how i make the connection between the where statement and the variable name

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

It should look like

SET vCustomer = '7527301'; Table:LOAD *FROM File.qvd (qvd) // or whatever sourceWHERE [Customer_Number] = $(vCustomer);

Hope that helps

[#3]

Perfect.

Thanks you very much