topic Re: Dataset Discovery in Integration, Extension & APIs

Dataset Discovery

Wed, 25 Mar 2015 20:56:30 GMT

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.

Re: Dataset Discovery

rwunderlich — Wed, 25 Mar 2015 22:57:01 GMT

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

Re: Dataset Discovery

Thu, 26 Mar 2015 01:31:48 GMT

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

rwunderlich — Thu, 26 Mar 2015 21:56:50 GMT

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

Re: Dataset Discovery

Fri, 27 Mar 2015 18:27:22 GMT

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

rwunderlich — Sat, 28 Mar 2015 00:19:23 GMT

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.