topic Re: Automatic Table creation in App Development

Automatic Table creation

Sgiri — Mon, 06 Apr 2020 16:16:48 GMT

Hello All,

I have an requirement to create an automatic table in Qliksense. I have Dimensions and Measures placed in a filter pane. When I filter a field in Dimension and a field in Measure automatic table should come up with the filtered records.

I don't wanna do it using inline function. Please help

Thanks All.

Re: Automatic Table creation

lorenzoconforti — Mon, 06 Apr 2020 16:49:07 GMT

See attached; hopefully this will be helpful. Essentially, you select dimensions and measures and the table will be populated as requested.

Re: Automatic Table creation

Sgiri — Wed, 08 Apr 2020 17:27:59 GMT

Hello Lorenzo,

Thanks for the Solution but I am looking for some different solution without using Inline table.

Re: Automatic Table creation

lorenzoconforti — Wed, 08 Apr 2020 17:43:03 GMT

Not sure what you are referring to. I've used an inline table in the script, just to load some sample data.

In your post you mention using measures and dimensions placed in filters to create dynamic tables. This applies to the front end, which is what I've posted: a solution to dynamically generate tables (in the front end) by selecting dimensions and measure from filters/drop down

Could you please clarify better what you are trying to achieve?

Re: Automatic Table creation

Sgiri — Fri, 17 Apr 2020 18:46:29 GMT

Hello Lorenzo,

I see you have used Variable Extension which will allow user to select only one value but my requirement is to select multiple dimensions and measures.

Thanks

Re: Automatic Table creation

lorenzoconforti — Mon, 20 Apr 2020 10:30:23 GMT

How many dimensions and measures are you planning to use? Also, how many tables will you be including?

There is another way to do this but it's a bit more complicated; it really depends on the requirement

Re: Automatic Table creation

Sgiri — Mon, 20 Apr 2020 16:15:00 GMT

Its just only one table and 25 Dimensions and 10 measures.

Re: Automatic Table creation

lorenzoconforti — Mon, 20 Apr 2020 16:54:31 GMT

See tab Dynamic Tables with field selections in the attached

Basically, you define dimensions and measures in the load script and create two separate data tables; you then provide two filters based on those two fields. Then, in your table, you enable/disable dimensions/expressions according to what has been selected. It's a bit more laborious than using variables but it's more flexible/user friendly once implemented