Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
MoxieMeister
Contributor II
Contributor II

Qlik Sense subfield for variable

Hi all,

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

This.png

1 Solution

Accepted Solutions
DavidM
Partner
Partner

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;

 

View solution in original post

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

What's the aim behind your logic?

- Marcus

DavidM
Partner
Partner

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;

 

View solution in original post