Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

francisco_cohen
New Contributor III

User input from user to script

Hi all,

I've found many discussions around this theme and maybe I've missed the correct answer to my issue - sorry if I did.

I'm using Qlik Sense DEKTOP version.

In my script I have a variable SEG1 and I want the user to input a value and then use a reload button to re-run the script using that input.

How can I use that user input value in the script?

This is my script:

SEG1='VBGT11B1486'; //value inut, hardcoded in the script and I want to replace this by an input box in the visualization

[BOM]:

SELECT DISTINCT LPAD (' ', LEVEL * 2) || LEVEL order_level

              , msib.segment1 assembly_item

              , msib.description assembly_description

FROM            bom.bom_components_b@EBS bic

WHERE           1 = 1

AND             bic.bill_sequence_id = bom.bill_sequence_id

AND             SYSDATE BETWEEN bic.effectivity_date AND Nvl(bic.disable_date, SYSDATE)

AND             bom.assembly_item_id = msib.inventory_item_id

AND             bom.organization_id = msib.organization_id

AND             bic.IMPLEMENTATION_DATE IS NOT NULL

START WITH      msib.segment1 = '$(SEG1)'               /*  component item to be used here */

CONNECT BY NOCYCLE PRIOR bic.component_item_id = msib.inventory_item_id

ORDER BY        PATH;

Thks,

FC.

4 Replies
shraddha_g
Honored Contributor III

Re: User input from user to script

Use Input Box in Front end Qlik Branch

It will change variables value.. and use reload button Qlik Branch

francisco_cohen
New Contributor III

Re: User input from user to script

I'm using the input variable, but it doesn't change the value.

Any idea why?

shraddha_g
Honored Contributor III

Re: User input from user to script

can you share sample app?

francisco_cohen
New Contributor III

Re: User input from user to script

Thank you, please check attached app.

Community Browser