Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
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 II
Partner - Contributor II

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 😄