Need to create a table with 350 fields for dnamic selection in qlik sense

[magic]

I want to create a table with 250 dimesions and 100 measures so that user selects fields in dim and measure then table should show data

it should not hang or hampers performance 

please help me on this request

[RafaelBarrios]

Hi @magic 

i think your best option is the "new" straight table

This table allows self-service so that each user can select the columns they want for their report.

I think there will be too much columns, so it's not immune to crashing, but your data model will also have a significant impact. For so many columns, I would suggest a large fact table instead of a star model.

Hope this help.
Best,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 

[priscilarubim]

Hi!

There's this option to enable Chart Exploration in the Straight Table... I'm not sure about the limit, but it would be something like this:

Step 1: Add a Straight Table to your sheet. From the assets panel on the left, drag a Straight Table chart onto the sheet and drop it where you want it placed.

Step 2: Add all dimensions and measures you want to make available to the user. Click on Add dimension and Add measure to populate the table with every field from your data model that should be selectable. At this stage, the table will look overloaded that's expected. We're building the full pool of fields that the end user will later filter from.

Step 3: Enable Chart Exploration in the properties panel. With the table selected, open the properties panel on the right and navigate to Appearance → Chart exploration. Check the box "Enable chart exploration".

Step 4: The user-facing self-service experience. Once enabled, the end user sees a Chart exploration panel on the left side of the table in analysis mode. They can:

• Search for fields in the search box
• Check/uncheck dimensions and measures to show or hide columns dynamically
• Reorder columns by dragging
• Build their own customized view without developer intervention

The table on the right updates in real time based on the user's selections.

[jpenuliar]

And if you find yourself wanting to bulk edit text-alignments or column width.
I have a free fancy tool to suggest. You will have to use "/options/developer" trick.

https://www.diffqs.com/table-editor

regards,

JP

[alexquimu]

Hi,

For handling the dimensions, I highly recommend using the QuickTableViewer extension (https://github.com/ChristofSchwarz/qsQuickTableViewer). This tool allows you to quickly add all fields from a specific data model table into your visualization and then convert it back into a standard table. There is no risk in using this extension because the final output becomes entirely Qlik-native.

Then hit GetmyTable:

The result is a simple table with all dimensions

For the self-service feature, change it to the new straight table from Qlik

Enable chart exploration as @priscilarubim clearly explained, and you will have your 250 dimensions ready to go, leaving you with just your measures.

This way, you can be sure you won't miss any dimensions 🙂

I highly recommend giving this extension a try.

Regards,