Dynamic User Charts Dimension values under variables?

[#1]

Hello Experts,

I have a requirement where the Users can create Dynamic charts off Excel files as seen in the forums here its a standard process. However the challenge lies when some new Dimensions are introduced into the Excel file and how to update them without changing anything in Qlik. Someone suggested the below solution, but now sure if or how it works?

You could do something like add this for dimensions 1- 20

='$(vDimx)' where x = 1 to 20

the variable is defined as

=Subfield(Concat(DISTINCT $Field, ','), ',', x) where x=1 to 20

Then display $Field as a list box- maybe omit some values like those with a hide prefix.

Now you have a dynamic report builder where all you entered for the dimensions are ='(vDim1)', ='(vDim2)' and even if you add a new field to the data model it will still be available in the report builder.

Cheers,

Qlikker