topic Add Variable to Load Script in QlikView

Add Variable to Load Script

Thu, 17 Mar 2011 12:00:49 GMT

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

Add Variable to Load Script

Miguel_Angel_Baeyens — Thu, 17 Mar 2011 12:04:14 GMT

Hello,

It should look like

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

Hope that helps

Add Variable to Load Script

Thu, 17 Mar 2011 12:10:35 GMT

Perfect.

Thanks you very much