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