topic Re: Create table box using $table in QlikView

Create table box using $table

Fri, 05 Sep 2014 15:02:58 GMT

I wonder whether there is a way to create dynamic table box for all data fields for selected table using $table

Like, you have table a, b, c

In table a, you have field a1, a2, ..., an

In table b, you have field b1, b2,..., bn

In table c, you have field c1, c2, ..., cn

We can create a list for $Table, which will list all tables in the app now.

if we select table a from $table list, I'd like to show all data field in table box for table a, like

a1 a2 a3 ... an

I appreciate any thoughts and any ideas. Thanks in advance!

Xianqun

Re: Create table box using $table

JonnyPoole — Fri, 05 Sep 2014 15:29:51 GMT

i haven't seen a way to dynamically create this, and the table box has no conditional show/hide feature to hide certain columns or not.

next best answer is to create a table box with all the columns for 1 table and repeat for the other tables. Put a show/hide condition on the table box so that it only shows if you are selecting the right table name from a list box.

The list box would just be a data island with the table names manually inputted . Or you can do a input box with a drop down with the same to set a variable (vTable) and use the vTable value to determine which table box shows and hides.

this is probably something you are already using though

Re: Create table box using $table

mikecrengland — Fri, 05 Sep 2014 15:38:33 GMT

Try using list boxes instead. One for $Table, one for $Field and one with and expression:

=$(='[' & Only([$Field])& ']')

mike

www.fortunecookiebi.com

Re: Create table box using $table

marcus_sommer — Fri, 05 Sep 2014 17:22:56 GMT

This isn't possible with a tablebox but you could easily use table-charts. There is already an object available by clicking on "New Object" --> "Structure Table".

- Marcus

Re: Create table box using $table

Anonymous — Sun, 07 Sep 2014 10:19:44 GMT

Xianqun

Have a look at the the QlikView App - Generic Data Profiler by Steve Dark

It will do what you want plus more.

Re: Create table box using $table

MarcoWedel — Sun, 07 Sep 2014 11:07:09 GMT

Hi,

one example:

hope this helps

regards

Marco

Re: Create table box using $table

evan_kurowski — Sun, 07 Sep 2014 16:39:42 GMT

Hello xianqun,

Try this in a Listbox:

=If(GetPossibleCount([$Table])>1, [$Table], Aggr(Only({<[$Field]>} [$Field]),[$Field]))