Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

String encapsulation with GetFieldSelections?

Is there a better way to use GetFieldSelections in an Set Analysis than this:

{<dimension_id={$(='"'&GetFieldSelections(possible_dimension_id,'","',2)&'"')}>}

All the '"'& is a bit ugly in my opinion, but it works.

Cheers

Karl

1 Solution

Accepted Solutions
Not applicable

Re: String encapsulation with GetFieldSelections?

Hi,

* Try to put the double-quote around the $(...) :

{<dimension_id={"$(=GetFieldSelections(possible_dimension_id,'" ,"',2))"}>}

* Your value separator is "," and not , ?

2 Replies
Not applicable

Re: String encapsulation with GetFieldSelections?

Hi,

* Try to put the double-quote around the $(...) :

{<dimension_id={"$(=GetFieldSelections(possible_dimension_id,'" ,"',2))"}>}

* Your value separator is "," and not , ?

Not applicable

Re: String encapsulation with GetFieldSelections?

Thanks for the reply,

I haven't tried your answer, because I ended up with a different solution. Forgot the set is applied for the entire HyperCube and not by rows.

I used '","' to get the result of "DimValue01","DimValue02". It worked, but wasn't pretty.