Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Luffy1994
Contributor II
Contributor II

Dynamic Table

Hi All,

I want to create a dynamic table where when i select a field name it should get add in table.

for e.g currently my table has 10 fields than my table should have all the then fields...

then once i add one more field in the script it should automatically add that field inside the table...

or 

i want an table with n dimension selected in using $fields

any idea how could we achieve that...

 

Thanks

Labels (4)
4 Replies
Mark_Little
Luminary
Luminary

Hi there,

I don't think that possible.

 

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

If you are ok with your Table chart showing a max number of columns, then you could predefine the columns like this:

Field:  =[$(=SubField(GetFieldSelections($Field, ','),',',1))]

Label:   =SubField(GetFieldSelections($Field, ','),',',1)

Show column if:  =GetSelectedCount($Field) >= 1

Repeat for the max number of columns you want, incrementing the index number -- "1" in the above.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Luffy1994
Contributor II
Contributor II
Author

but for above problem i need to create the expression or dimension place holder manually right...
i would be not sure how many columns would be there...

TiDriv3r
Partner - Contributor
Partner - Contributor

I have the same issue, that I need a dynamic table where I don't know how much columns are going to be. They shoulb be automatically added when I choose the Items within a Dimension. Of course for performance reasons that table should have a limit parameter or such object would crash if a dev is not paying attention on the ram usage

I try it on myself with building a extension... but at the moment I am not sure whether I will succeed.
If anybody has already a possible solution, then I think a lot poeple would be very thankfull 😄