Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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

 

0 Replies