topic Re: Variable with field name inside in QlikView

Variable with field name inside

danosoft — Tue, 08 Oct 2019 10:35:59 GMT

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....

sunny_talwar — Tue, 08 Oct 2019 11:28:26 GMT

May be add an equal sign

$(=varOne)

danosoft — Tue, 08 Oct 2019 13:14:13 GMT

no, it not work

sunny_talwar — Tue, 08 Oct 2019 13:28:55 GMT

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

asinha1991 — Tue, 08 Oct 2019 13:39:55 GMT

maybe this

[ $(varOne)]

or " $(varOne)"

danosoft — Tue, 08 Oct 2019 13:41:46 GMT

no it show the fieldName not the values

danosoft — Tue, 08 Oct 2019 13:59:41 GMT

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

sunny_talwar — Tue, 08 Oct 2019 14:04:42 GMT

Try this

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

danosoft — Tue, 08 Oct 2019 14:11:05 GMT

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

sunny_talwar — Tue, 08 Oct 2019 14:32:13 GMT

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