topic Re: Dynamic table creation based on user selection in QlikView

Dynamic table creation based on user selection

krishnakv83 — Wed, 25 Nov 2020 16:16:04 GMT

Team,

I created five text object button for dimensions.Based on the user selection on the dimension button my table should be created.

Ex: if users selected 3 dimesion button those 3 dimension should be included in the table.

is it possible to get?

Regards,

Venkat

Re: Dynamic table creation based on user selection

Or — Thu, 09 Nov 2017 12:08:23 GMT

There's several ways to do this, yes. My preferred way is to have users select 1 to X dimensions, each in its own field, and then use that to generate the table. If you need the selections to be in a single field, that's possible too.

See Dynamic charts or search for QlikView Dynamic Charts for examples and details.

Re: Dynamic table creation based on user selection

jpenuliar — Thu, 09 Nov 2017 12:18:27 GMT

Have a look at this tutorial:

QlikView How To (or Tips & Tricks) Application

a good example on Quick Reports

Re: Dynamic table creation based on user selection

krishnakv83 — Thu, 09 Nov 2017 12:23:02 GMT

Thank you for quick reply.

First I tried creating lix box with my all the columns using the inline script.The Dashboard is multi language based on country drop down.My Inline labels are limited to English and could not convert to other languages dynamical.

hence tried with button.

The solution which you showed also on the line statement.

Please let me know any other way

Regards,

Venkat

Re: Dynamic table creation based on user selection

Or — Thu, 09 Nov 2017 12:26:04 GMT

If you want to do it this way, you'll may have to go the long way around - set up a dimension for each possible selection and display/hide it dynamically based on whether the user selected that particular field. You should be able to use Dual() to give each possible selection a number so you only have to write one condition instead of one per language.

Re: Dynamic table creation based on user selection

krishnakv83 — Thu, 09 Nov 2017 12:28:54 GMT

Yes I need to do.That is the requirement.

Can you please explain me in more detailed way.

Regards,

Venkat

Re: Dynamic table creation based on user selection

krishnakv83 — Thu, 09 Nov 2017 13:45:02 GMT

Any other ideas to get this requirement

Appreciate for quick reply

Regards,

Venkat