topic Re: If i create input box,and input one value,can i use this value in my select sql? in QlikView

If i create input box,and input one value,can i use this value in my select sql?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

for example:

my select sql:

select * from tablename where columnname = 'my input value';

when i click select button,the page can refresh the data.

juraj_misina — Tue, 23 Oct 2018 07:50:13 GMT

Yes, you can do this. You need to connect the input box to a variable and then use that variable in the load script.

select * frmo tablename where columnname='$(variablename)';

assign a Reload action to the "select" button.

Anonymous — Wed, 24 Oct 2018 06:01:01 GMT

thanks for your help,I had resolved.

But if user input value is null,and then click "select" button,how can i used '20180101' to replace the input value?

juraj_misina — Thu, 25 Oct 2018 07:07:55 GMT

Hi,

you can do this by

If(Len('$(variablename)')=0 then

LET variablename = '20180101';

EndIf