topic Load the table based on field selection in QlikView

Load the table based on field selection

jeevays7 — Tue, 27 Mar 2018 07:53:46 GMT

Hi All,

1. I have a field("TABLE") which contains all the table name from Database.

Now i am selecting a table name from the field("TABLE") , and reload the the document using button click.

so i need to fetch all the data for the selected Table name only from ("TABLE") field.

How can we achieve this?

2. Can we update one table and not others while reload the document ?

shiveshsingh — Tue, 27 Mar 2018 08:19:41 GMT

1.Make a variable and store the value of that Field in that variable(on selection)

then use it in your reload script like ..load * from $(Variable)

2. You can use partial reload for this.

jeevays7 — Tue, 27 Mar 2018 08:25:00 GMT

Thanks for your reply Shivesh,

I tried the first one. but it is not working. can you share sample file?

shiveshsingh — Tue, 27 Mar 2018 08:41:47 GMT

on your button, set below action

1.Set variable_name = getfieldselections(FieldName)

2.Reload

What error are you getting? can you share your app?

jeevays7 — Tue, 27 Mar 2018 10:56:34 GMT

Hi Shivesh,

When i am using the variable(variable_name) in where clause, it is showing the variable value

as "getfieldselections(FieldName)". so it is not working.

stabben23 — Tue, 27 Mar 2018 11:15:39 GMT

Create a dropdown list With like this, then use '$(vFilter)' in where clause

stabben23 — Tue, 27 Mar 2018 11:26:25 GMT

You could also create a variable vreloadAll which helps you to load all tables again if needed.

So if vreloadAll is Yes all tables will be loaded again and you could Select another table to load.

if '$(vreloadAll)' ='Yes' then
Select *
FROM
Database
;
else
Select *
FROM
Database
where TABLE= '$(vFilter)'
;