Dataset Discovery

[#1]

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.

[rwunderlich]

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!

-Rob

http://masterssummit.com

http://robwunderlich.com

[#3]

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]

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

[#5]

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]

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.