topic Re: Generate a dynamic table in Integration, Extension & APIs

Generate a dynamic table

mattias_thalen — Thu, 02 Dec 2021 10:18:41 GMT

Hi,

I frequently create dynamic tables, as described here: https://www.ometis.co.uk/creating-a-dynamic-table-in-qlik-sense/

This is very time consuming, especially when there is more than 50 available dimensions.

Is there a way to create an extension that would do these step for me?

Re: Generate a dynamic table

Or — Thu, 02 Dec 2021 10:59:44 GMT

There are already extensions that do similar things, and are generally quite robust. Have a look at e.g. https://community.vizlib.com/support/solutions/articles/35000128354-vizlib-custom-report-introduction

though other solutions exist for the same problem (I happen to use the Vizlib one as a customer).

Of course, if someone else managed to do it, you probably could too, if you'd prefer to make your own extension.

Re: Generate a dynamic table

mattias_thalen — Thu, 02 Dec 2021 14:12:49 GMT

Actually, I ended up forking qsQuickTableViewer and added a dynamic table option 🙂

https://github.com/mattiasthalen/qsQuickTableViewer/tree/Dynamic-Table-Option

Re: Generate a dynamic table

qlikster — Thu, 01 Dec 2022 15:08:16 GMT

Hi Mattias,

Are you also able to drop measures in this version/fork?

Re: Generate a dynamic table

mattias-thalen — Thu, 01 Dec 2022 19:58:41 GMT

I did a new project for it and just added support for measures. Don’t have any examples there on how to do it.

But the basic idea is that you create a table in the model that lists the measure label, measure var name, one field each.

When I have time I will add a better demo in the repository.

Something I’m quite proud of is that I stumbled on the formula to extract the dimension/measure name. So the first dimension column always shows the first selected dimension, the second dimension column the second dimension, etc. And the same for measures. You also select the maximum number of selectable columns of each type.

Have a look here, feel free to fork it and play around ☺️

DynamicTable