topic Re: Help with a qv script/dashboard need to populate tbl based on variable in QlikView

Help with a qv script/dashboard need to populate tbl based on variable

buffalome90210 — Wed, 23 Jul 2014 20:26:53 GMT

This is a very simple example.

I have a an excel table in this example about 10 rows.

this is defined as table1 and then becomes table2 via a subsequent resident load.

The form has an inputbox with the variable field variable1.

I then have a table which can display "table2" with the addtional field "mytable_target" which is populated via the inputbox.

I want to have that table regenerated every time a change is made to Variable1 via the inputbox.

This is a small example of a much larger dashboard, the crux is, the change must be made to the Table, listboxes, etc will not suffice.

I have attached the QV file and the excel datatable.

Any suggestions will be appreciated.

Terence

table1:

LOAD dr_name,
met,
autonum
FROM
DataTable.xlsx
(ooxml, embedded labels, table is Sheet1);

table2:
LOAD dr_name,
met,
autonum,
$(Variable1) as mytable_target

resident table1;

Re: Help with a qv script/dashboard need to populate tbl based on variable

Wed, 23 Jul 2014 20:32:48 GMT

May I ask whats the reason you want to add this to the back-end table. So basically Table2 is nothing but Table1 + variable field.

What purpose does Table 2 serve.

Just trying to understand.

Thanks

Re: Help with a qv script/dashboard need to populate tbl based on variable

buffalome90210 — Wed, 23 Jul 2014 20:38:16 GMT

Table2 will eventually contain a group by.

But if you want to provide the solution for table1, I can integrate that solution.

TY for looking at this.

Terence

Re: Help with a qv script/dashboard need to populate tbl based on variable

Wed, 23 Jul 2014 21:01:29 GMT

I think you have to use EDX. Thats the only way the table will be updated whenever you change the value of the variable( ie reload the application)

You can check out these posts:

How to enable users to Reload data from time to time from the QV Acces Point?

Question: How to Reload from the Accesspoint without Publisher