Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Variable with field name inside

I have a variable in my load script that have a field name:

varOne = "fieldName"

i want use the values of that fieldName in my chart dimension, how can i do that?

if  i use in my dimension $(varOne) it write only the fieldName and not all values at that filedName have in my table....

1 Solution

Accepted Solutions
Highlighted

Re: Variable with field name inside

Try this

=$(='[' & $(varFirDimension) & ']')

View solution in original post

9 Replies
Highlighted

Re: Variable with field name inside

May be add an equal sign

$(=varOne)

Highlighted
Creator III
Creator III

Re: Variable with field name inside

no, it not work

Highlighted

Re: Variable with field name inside

Would you be able to share a sample to show your issue?

Highlighted
Creator III
Creator III

Re: Variable with field name inside

maybe this

[ $(varOne)

 

or " $(varOne)"

Highlighted
Creator III
Creator III

Re: Variable with field name inside

no it show the fieldName not the values
Highlighted
Creator III
Creator III

Re: Variable with field name inside

This is the example, i try to explain it:

- when in the Dimension table i select "AGENTE"

i want in the Chart table see on the rows:

agenteuno

agentedue

agentetre

and NOT the name of the field

Highlighted

Re: Variable with field name inside

Try this

=$(='[' & $(varFirDimension) & ']')

View solution in original post

Highlighted
Creator III
Creator III

Re: Variable with field name inside

thanks it work!! can you explain the solutions? thanks
Highlighted

Re: Variable with field name inside

Dollar sign expansion converts a text into a field name... $(Variable) gives text, $(='[' & $(Variable) & ']') gives [FieldName]