Automatic Table creation

[Sgiri]

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.

[lorenzoconforti · Accepted solution]

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

[Sgiri]

Hello Lorenzo, 

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

[lorenzoconforti]

 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?

[Sgiri · Accepted solution]

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

[lorenzoconforti]

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

[Sgiri]

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

[lorenzoconforti]

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