topic Re: How to load records from a table based on parameter value in QlikView

How to load records from a table based on parameter value

rahulhv1 — Fri, 27 Dec 2013 07:22:30 GMT

Hi,

I have a table of contains DEPT,MCNO, ATTDATE, LNAME. I wish to load data on the basis of parameter value of DEPT.

i.e. if i set value of parameter DEPT = 'HR' then rows having dept HR should be retrieved. In above example i do not want to create any LIST BOX for any selction. I just want end user to write name of the dept. and data shuould be filterd out.

Re: How to load records from a table based on parameter value

Gysbert_Wassenaar — Fri, 27 Dec 2013 07:38:02 GMT

Add a searchbox object. Add only the DEPT field and set the Default Search Mode to Use Normal Search

Or add an inputbox object to your sheet and create a new variable for it, e.g. vDept. Then open the document properties window and go to the Triggers tab. Select the vDept variable and click on the Add Action(s) below OnInput. Add a Select in Field action. Use DEPT as field and =vDept as Search string.

Re: How to load records from a table based on parameter value

sujeetsingh — Fri, 27 Dec 2013 08:15:26 GMT

Gysbert is right you can set a variable with the given DEPT value and then use conditional load with exsist function .