Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Not applicable

Dataset Discovery

Is there a way to list all available tables (and then columns once a table is selected) from a Qlik Sense app? If not, is there a way to get a list of tables/columns using something like a HyperCube or another method that would allow me to display this in some interactive way on a web page? I need to allow a user of the web app to see what is available to them.

Tags (3)
5 Replies

Re: Dataset Discovery

The meta fields:

$Table -- tables in the app

$Field -- Fieldnames in the tables

are available in Sense, although they don't show up in the dialogs. But you can just type them in as a Dimension in a Table or Filter pane. Try it out!

2015-03-25_18-56-09.jpg

-Rob

http://masterssummit.com

http://robwunderlich.com

Not applicable

Re: Dataset Discovery

Fantastic, thank you! Next question: When selecting a table name, is there as simple a way to display the data from that table in a Qlik Sense table? Basically, "SELECT * FROM [selected_table_name] LIMIT 100;" in a table object.

Re: Dataset Discovery

Yes. Create a Filter Pane or Table with this Dimension:

=[$(=minstring($Field))]

and for the Title:

=minstring($Field)

That will show all rows, not just 100.

-Rob

http://masterssummit.com

http://robwunderlich.com

Not applicable

Re: Dataset Discovery

Hmmm, that doesn't seem to be working. I need to show all columns for the selected table, so basically a flat table with a dynamically generated number of dimensions, one per available column in the table. This is just the first column (alphabetically) with it's values beneath it. Unless of course I'm doing something wrong.

Re: Dataset Discovery

My misunderstanding. I thought you wanted to show values of the selected field.

That's challenging. You could use Dimension values like

=[$(=only({<$FieldNo={1}>}$Field))]

=[$(=only({<$FieldNo={2}>}$Field))]

But that would not show rows of the table, but rather unique combinations of values. Which would only equal rows if you had a primary key field.

Community Browser