Generate a dynamic table

[mattias_thalen]

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?

[Or]

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-introductio...

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.

[mattias_thalen · Accepted solution]

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

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

[qlikster]

Hi Mattias,

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

[mattias-thalen]

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