Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
krishnakv83
Contributor II
Contributor II

Dynamic table creation based on user selection

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

6 Replies
Or
MVP
MVP

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.

jpenuliar
Partner - Specialist III
Partner - Specialist III

Have a look at this tutorial:

QlikView How To (or Tips & Tricks) Application

a good example on Quick Reports

krishnakv83
Contributor II
Contributor II
Author

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

Or
MVP
MVP

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.

krishnakv83
Contributor II
Contributor II
Author

Yes I need to do.That is the requirement.

Can you please explain me in more detailed way.

Regards,

Venkat

krishnakv83
Contributor II
Contributor II
Author

Any other ideas to get this requirement

Appreciate for quick reply

Regards,

Venkat