Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Partner
Partner

Pass a variable in partial reload

Hello,

I want to use a variable in a partial reload :

The user select values in a field [OF(Order)] then he clicks on the partial reload button.

A variable contains selected values is visible in the user interface : vQueryText = Concat([OF(Order)],',')

In the script, I want to use this variable to filter data with a match :

add Only
NoConcatenate
MACHINE_DATA:
LOAD
*,
[nominal scrap rate] as scrap
FROM [lib://QV_APPLI (QLIK SENSE)/ANALYTIC_PLATFORM\QVD\D_ANALYTIC_COLUMN.qvd]
(qvd)
where match(OF, '$(vQueryText)')
;

The problem is that I can't retrieve the value of the variable, 

2019-07-17 06:20:41 0101 if not IsPartialReload() then
2019-07-17 06:20:41 0208 if IsPartialReload() then
2019-07-17 06:20:41 0210 add Only
2019-07-17 06:20:41 0211 NoConcatenate
2019-07-17 06:20:41 0212 MACHINE_DATA:
2019-07-17 06:20:41 0213 LOAD
2019-07-17 06:20:41 0214 *,
2019-07-17 06:20:41 0215 [nominal scrap rate] as scrap,
2019-07-17 06:20:41 0216 'load_script=true,scaler=quantile,min_cluster_size=3,min_samples=2,cluster_selection_method=leaf' as Args
2019-07-17 06:20:41 0217 FROM [lib://QV_APPLI (QLIK SENSE)/ANALYTIC_PLATFORM\QVD\D_ANALYTIC_COLUMN.qvd]
2019-07-17 06:20:41 0218 (qvd)
2019-07-17 06:20:41 0219 where match(OF, '=vQueryText')

I try with a lot of syntax like '$(vQueryText)' , $(vQueryText) but the value of the variable is never transmitted to the script.

Do you know if I can use a variable in Qlik Sense Interface, set this variable, and then transmitted the value to the script.

Thanks !

Paul

 

Tags (3)