topic Re: Pass filter value to Data load script in Qlik Sense in App Development

Pass filter value to Data load script in Qlik Sense

Bhavani — Fri, 29 Nov 2019 09:37:15 GMT

Hi All,

Is there a way where a filter value could be passed to data load script ?

I have tried using GetFieldSelections and other functions but they are not getting values passed rather passing the function as is.

Also , tried assigning the evaluated value to another variable but that also showing the function as is.

Thanks

Re: Pass filter value to Data load script in Qlik Sense

lanlizgu — Fri, 29 Nov 2019 10:20:45 GMT

What you can do is:

Declare a variable in the script set vVariable=GetFieldSelections(FieldToFilter);
Add a Navigation & Actions Button in the App and set a variable value
1. variablename: vVariable2
2. Value: =$(vVariable)
You would need to create a partial reload button and add the following to the script:
1. Variable:
  add Load
  '$(vVariable2)' as Variable
  autogenerate (1);
  
  VariablebyLine:
  ADD LOAD
  subfield(purgechar(Variable, chr(10)),',',$(i)) as Variable_NUMBER
  RESIDENT Variable
  Where Len(subfield(purgechar(Variable, chr(10)),',',$(i)))>0;
  NEXT
In that way you would obtain the specific filter that you are doing inside the script

Re: Pass filter value to Data load script in Qlik Sense

Bhavani — Fri, 29 Nov 2019 11:07:15 GMT

Hi lanlizgu ,

Many Thanks for your suggestion.

I have tried the steps given by you. But,I am unable to get the field selected value to data load editor script.

Can you please share a qvf for this?

Thanks,

Bhavani

Re: Pass filter value to Data load script in Qlik Sense

lanlizgu — Fri, 29 Nov 2019 11:18:53 GMT

Please find attached a QVF that will store in a variable the selection done in a field (just select 1 value, for more values you would need to develop as mentioned):

You select 1 year
You click on My Button
You Click on Validar
Once the partial reload is done you will see in the vVariable2 variable the selected year

You need to have the reload_partial extension and Navigation & Actions installed

Re: Pass filter value to Data load script in Qlik Sense

Bhavani — Fri, 29 Nov 2019 11:54:55 GMT

The extensions holders in the app says invalid visualization inspite of having the extensions in place.

Do I have to select any navigation action ? or should it be none.?

Re: Pass filter value to Data load script in Qlik Sense

lanlizgu — Fri, 29 Nov 2019 12:26:23 GMT

You can't see none of the extensions?

for the Navigation + Actions

https://github.com/stefanwalther/sense-navigation

PFA the reload partial extension

Re: Pass filter value to Data load script in Qlik Sense

AyushSingh — Wed, 14 Aug 2024 04:23:41 GMT

Hi , thanks for your help . I implemented this thing in my solution and it is working also but the major drawback is that when I am reloading my app for the particular input parameter the application is reloading for all the users who had opened this app parallely . Which is not correct behaviour to represent the data.