Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

5 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Author

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.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Author

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.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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.