Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi there,
I don't think that possible.
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
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...
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 😄