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
