Qlik Sense subfield for variable

[MoxieMeister]

Hi all,

I need read variable "Currency" to subfield, but catch error. 

[marcus_sommer]

What's the aim behind your logic?

- Marcus

[DavidM · Accepted solution]

You are resident loading from table and use no fields. What do you expect out of this? If your expected outcome is:

1GBP

2GBP

...

you need to do:

load
return&subfield('$(Currency)',';',1)  as Currency
resident t1;