topic Re: How to pass input box value to sql query as a parameter? in QlikView

How to pass input box value to sql query as a parameter?

Tue, 14 Jul 2015 10:21:40 GMT

Hi All,

I am trying to achieve something here, can you please help me out here. Below is what I am trying to do:

In my QV application, I need run a sql query that takes parameters from the user, so I was thinking to have input box where in the user can enter the value, this value would be save in a variable and then the user will reload the app? Do you think this would work? I am just getting confused. Any help here would be greatly appreciated.

Example Select * from tablename where date = : p_date

p_date is given by the user.

So,. should I make this as an input box and save its value in a variable so that on reload, what ever date the user has entered that will be used in the query?

Thanks

Re: How to pass input box value to sql query as a parameter?

qlikmsg4u — Tue, 14 Jul 2015 10:25:48 GMT

Hi Pragathi,

You are right that's possible (But only in Desktop).Please find the attached app

Re: How to pass input box value to sql query as a parameter?

phaneendra_kunc — Tue, 14 Jul 2015 10:27:45 GMT

Assuming user will on Desktop, or other wise they dont even see the realod option. Unless you are using some thing like EDX and Webservices.

Use it like below. p_date is your variable. In this case you can create a calendar object and assign this p_date as a variable. so that your user selections will gets stored in this variable and you can use this in the sql code to filter.

Select * from tablename where date = '$(p_date)'

Re: How to pass input box value to sql query as a parameter?

Tue, 14 Jul 2015 10:30:25 GMT

Thanks very much, this is exactly what I was looking for.

You are a star. 😄

Re: How to pass input box value to sql query as a parameter?

ashfaq_haseeb — Tue, 14 Jul 2015 10:31:16 GMT

Hi,

Check this

LET vDate = Input('Input Date', 'Warning!');
Select * from tablename where date = $(vDate)

Regards

ASHFAQ

Re: How to pass input box value to sql query as a parameter?

Tue, 14 Jul 2015 10:32:43 GMT

Thanks for your response, the user is actually using desktop version, so he will have access to the reload button. You response is also the same as QLIKmsg4u‌ He just supplied with an example which is what I was looking for.

Thanks once again,

Re: How to pass input box value to sql query as a parameter?

Tue, 14 Jul 2015 10:39:26 GMT

Can you please tell me what does vShow variable do? where is it used in your example application?

Thanks

Re: How to pass input box value to sql query as a parameter?

qlikmsg4u — Tue, 14 Jul 2015 11:04:32 GMT

Hi Prahathi,

Variable vShow has nothing to do with your requirement, i used it for other purpose

Re: How to pass input box value to sql query as a parameter?

Tue, 14 Jul 2015 11:06:04 GMT

Ohh Okay, thanks